[GENERAL] win-1251 cyrillic support ?

[raptor]

hi,

I have setup postgres db with WIN ecnoding (i.e. win1251)...but when i enter 
data the cyrillic is not preserverd and all that goes in/out the DB is  
garbage-characters ?
Why is this that way is there any solution ?

I'm entering data via web-perl app and via pgadmin3 ..

if any additional info is needed ?
gentoo
dev-db/postgresql (7.4.6)
apache 1.3/mod_perl

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[GENERAL] spreading the DB?

[raptor]

hi,

what do u do if the DB become big and u have to spread
it into two or more computers.
Links and Docs are ok too ?

For example what if u do if u want to split the DB on two servers (at desing stage), 
but
u have common data such as user info,address etc... if u decide to do it that way
u need to syncronize common data in some way, what do u do.


tia

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[GENERAL] change encoding ?

[raptor]

hi,

how to change encding of already created database wo win-1251 ?

tia

---(end of broadcast)---
TIP 8: explain analyze is your friend

[GENERAL] dumping the schema ?

[raptor]

hi,
how can I dump the db schema so that I can recrate the DB later ?

tia

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

[GENERAL] comparing dates with timestamps ?

[raptor]

how to compare dates with timestamp..if i dont care about 
the hour:minute part of the timestamp... i.e. i want
to be able to do exact match :

timestamp in (select date from table where .)
 

tia

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq