Postgres Pro
Downloads
Home   >   mailing lists

Re: Syntax To Create Table As One In Another Database - Mailing list pgsql-general

From Rich Shepard
Subject Re: Syntax To Create Table As One In Another Database
Date
Msg-id alpine.LNX.2.00.1111151100560.30012@salmo.appl-ecosys.com
Whole thread Raw
In response to Syntax To Create Table As One In Another Database  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view 
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
> "<something>.<tablename>" is reserved for "SCHEMA" usage within
> PostgreSQL.

David,

   This was pointed out to me.

   What I did was display the schema for the table, then use it to create a
similar table in the new database.

Thanks,

Rich

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: PostgresSQL 8.4 to 9.0 on Windows 7
Next
From: "David Johnston"
Date:
Subject: Re: Syntax To Create Table As One In Another Database