On Wed, 28 Nov 2001, Joern Reder wrote:
> Thanks for your answer. With other words: there exists no SQL command in
> PostgreSQL to switch the current selected database?
There is no SQL command. Some PostgreSQL clients support this with their
own built-in command (like psql's /c command).
> Is it possible to select data from a another database than the current
> selected, like many other database systems support it (e.g. Oracle,
> Sybase, Informix, MySQL...), like this:
>
> select *
> from dbname.tablename
>
> This syntax does not work with PostgreSQL:
This is a planned feature in PostgreSQL, AFAIK, but is not yet available.
-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
PUNK ROCK!! DISCO DUCK!! BIRTH CONTROL!!