On 11/15/11 8:42 AM, Rich Shepard wrote:
I need a pointer to the appropriate docs that show me how to specify a
table in a different database.
What I want is to CREATE TABLE <tablename> AS TABLE
<otherdatabase><same_tablename>; but using a period (dot) to separate the
source database and table name doesn't work. My searches of the 9.0.x
docs
have missed finding this information.
use Schemas instead of databases if this is what you need. Combined
with search_path, this will get you the exact results you're looking
for. in fact, the default search_path is $USER,public, so it will look
in a schema named after the current user before it looks in the default
schema...
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
