Postgres Pro
Downloads
Home   >   mailing lists

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

From Joost Kraaijeveld
Subject How do I copy part of table from db1 to db2 (and rename the columns)?
Date
Msg-id 1125482430.9456.6.camel@Panoramix
Whole thread Raw
Responses Re: How do I copy part of table from db1 to db2 (and rename the columns)?  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
Re: How do I copy part of table from db1 to db2 (and rename the columns)?  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: [GENERAL] How do I copy part of table from db1 to db2 (and rename the columns)?  (Roman Neuhauser <neuhauser@sigpipe.cz>)
List pgsql-sql
Tree view 
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...

TIA

Joost

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: [ADMIN] plpgsql question
Next
From: Kenneth Gonsalves
Date:
Subject: Re: How do I copy part of table from db1 to db2 (and rename the columns)?