# J(dot)Kraaijeveld(at)Askesis(dot)nl / 2005-08-31 12:00:30 +0200:
> 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...
check these man pages: pg_dump(1), pg_restore(1), alter_table(7)
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991
In response to
pgsql-sql by date
|Next:||From: Joost Kraaijeveld||Date: 2005-08-31 12:00:03|
|Subject: Re: How do I copy part of table from db1 to db2 (and|
|Previous:||From: Kenneth Gonsalves||Date: 2005-08-31 10:15:49|
|Subject: Re: How do I copy part of table from db1 to db2 (and rename the columns)?|
pgsql-general by date
|Next:||From: Ben-Nes Yonatan||Date: 2005-08-31 11:04:27|
|Subject: Re: detection of VACUUM in progress|
|Previous:||From: David Sankel||Date: 2005-08-31 10:30:14|
|Subject: Removing all users from a group|