[GENERAL] Multiple database queries

2005-10-02 Thread Cosmopo
Hello, I was using many years ago Sybase that was able then to query several tables that could be located in more than one database... I know that Postgresql did not at the time have this capability. Does the new version 8.0.x ofter this feature? We need to create several databases based on our c

[GENERAL] Looking for a command to list schemas

2005-10-26 Thread Cosmopo
Hello, We are presently experimenting with Postgresql schemas... We used basic commands like \d to list info from all tables/sequence/owner in a db... The schema info was always "public" since we never created one... In version 7.3.4 and with a test db where schemas were created, the same \d doe