Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Syntax To Create Table As One In Another Database
Date
Msg-id alpine.LNX.2.00.1111150834490.10200@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Syntax To Create Table As One In Another Database  ("David Johnston" <polobo@yahoo.com>)
Re: Syntax To Create Table As One In Another Database  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
   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.

TIA,

Rich

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: all non-PK columns from information schema
Next
From: LPlateAndy
Date:
Subject: Re: encoding and LC_COLLATE