Re: Syntax To Create Table As One In Another Database

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