[GENERAL] PostgreSQL 8 compiling for Windows

2005-02-28 Thread Konstantin Danilov
Hello list I need to compile postgres 8 for Windows to set up the locale support. The distributive accessible from FTPs does not support it, and I cannot sort Russian letters - that's why.. I have MS Visual Studio 6, but I've never worked with it. So, how can I do everything? -

[GENERAL] How to view the list of tables?

2005-02-15 Thread Konstantin Danilov
Hello, list! I need to view the list of tables in a database. In MySQL I can do it with the command "SHOW TABLES". What about PostgreSQL? Can I also see somehow the datatypes of tables' fields? Konstantin ---(end of broadcast)--- TIP 6: Have you se

[GENERAL]

2004-12-06 Thread Konstantin Danilov
Hello List! PostgreSQL 8 does not correctly sort words written in cyrillic. It is a bug I suppose :) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL]

2004-11-27 Thread Konstantin Danilov
Hello List! Do you know how many times can JOIN be used in a query? How many JOINs does PostgreSQL support? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] how many JOINs?

2004-11-27 Thread Konstantin Danilov
Hello List! Do you know how many times can JOIN be used in a query? How many JOINs does PostgreSQL support in ONE query? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to

[GENERAL] PostgreSQL certification

2004-11-17 Thread Konstantin Danilov
Hello everyone! I have a question.. Does PostgreSQL have official certification? If yes, where can I find certification courses to get a certificate? Konstantin ---(end of broadcast)--- TIP 8: explain analyze is your friend