Re: Syntax To Create Table As One In Another Database

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Syntax To Create Table As One In Another Database
Date: 2011-11-15 19:01:59
Message-ID: alpine.LNX.2.00.1111151100560.30012@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-11-15 19:29:46 Re: Syntax To Create Table As One In Another Database
Previous Message David Johnston 2011-11-15 18:56:05 Re: Syntax To Create Table As One In Another Database