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!!

Reply via email to