Postgres Pro
Downloads
Home   >   mailing lists

Schema / Database SELECT support? - Mailing list pgsql-sql

From Clark Evans
Subject Schema / Database SELECT support?
Date
Msg-id 36D5F714.7637EC70@manhattanproject.com
Whole thread Raw
In response to Re: [SQL] PL/Perl?  ("Dr. Nisai Wanakule" <nisai@m1p17-235.waterauthority.state.fl.us>)
List pgsql-sql
Tree view 
I tried:

SELECT * FROM DB_A.MY_TABLE;

from DB_B and it did not like the
syntax.  I assume that you cannot
select across database/schemas.

Is this correct?

:) Clark Evans

pgsql-sql by date:

Previous
From: Clark Evans
Date:
Subject: OID Behavior
Next
From: Remigiusz Sokolowski
Date:
Subject: Re: [SQL] CREATE TABLE