Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I copy part of table from db1 to db2 (and rename the columns)? - Mailing list pgsql-sql

From Kenneth Gonsalves
Subject Re: How do I copy part of table from db1 to db2 (and rename the columns)?
Date
Msg-id 200508311545.49846.lawgon@thenilgiris.com
Whole thread Raw
In response to How do I copy part of table from db1 to db2 (and rename the columns)?  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-sql
Tree view 
On Wednesday 31 Aug 2005 3:30 pm, Joost Kraaijeveld wrote:
> Hi,
>
> I want to copy several columns of a source table from db1 to db2,
> and create the target table and rename the columns in the process.
>
> Is that possible in PostgresQL? If so, an example or url for such a
> command /script would be appreciated...

checkout dblink
--
regards
kg

http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!

pgsql-sql by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: How do I copy part of table from db1 to db2 (and rename the columns)?
Next
From: Joost Kraaijeveld
Date:
Subject: Re: [GENERAL] How do I copy part of table from db1 to db2 (and