[GENERAL] win-1251 cyrillic support ?

2005-04-29 Thread 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 in

[GENERAL] spreading the DB?

2004-11-01 Thread 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

[GENERAL] change encoding ?

2005-01-27 Thread 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 ?

2005-01-29 Thread 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 ?

2005-02-13 Thread 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