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 AS TABLE
; but using a period (dot) to separate the
source database and table name doesn't work. My searches of the 9
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rich Shepard
Sent: Tuesday, November 15, 2011 11:42 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Syntax To Create Table As One In Another Database
I need a
On Tue, 15 Nov 2011, David Johnston wrote:
Aside from roles/users each database exists in isolation and so what you
describe cannot be done. The syntax you describe
"." is reserved for "SCHEMA" usage within
PostgreSQL.
David,
This was pointed out to me.
What I did was display the schema
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 AS TABLE
; 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 informa
