How do I copy part of table from db1 to db2 (and rename the columns)?

From:	Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To:	Pgsql-sql(at)postgresql(dot)org, Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject:	How do I copy part of table from db1 to db2 (and rename the columns)?
Date:	2005-08-31 10:00:30
Message-ID:	1125482430.9456.6.camel@Panoramix
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2005-08-31 10:00:30 from Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>  2005-08-31 10:15:49 from Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>  2005-08-31 10:40:11 from Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>   2005-08-31 12:00:03 from Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>    2005-08-31 12:09:15 from Thomas Pundt <mlists(at)rp-online(dot)de>     2005-08-31 12:14:26 from Thomas Pundt <mlists(at)rp-online(dot)de>      2005-08-31 15:02:17 from Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>    2005-08-31 12:47:18 from Tino Wildenhain <tino(at)wildenhain(dot)de>    2005-08-31 14:29:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2005-08-31 15:14:08 from Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>  2005-08-31 13:19:00 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Lists:	pgsql-general pgsql-sql

Responses

• Re: How do I copy part of table from db1 to db2 (and rename the columns)? at 2005-08-31 10:15:49 from Kenneth Gonsalves
• Re: How do I copy part of table from db1 to db2 (and rename the columns)? at 2005-08-31 10:40:11 from Roman Neuhauser
• Re: How do I copy part of table from db1 to db2 (and rename the columns)? at 2005-08-31 13:19:00 from Greg Sabino Mullane

Browse pgsql-general by date

	From	Date	Subject
Next Message	Kenneth Gonsalves	2005-08-31 10:15:49	Re: How do I copy part of table from db1 to db2 (and rename the columns)?
Previous Message	Peter Arwanitis	2005-08-31 09:40:10	Searching for LTree dmoz-testdata

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Kenneth Gonsalves	2005-08-31 10:15:49	Re: How do I copy part of table from db1 to db2 (and rename the columns)?
Previous Message	Michael Fuhr	2005-08-31 02:32:49	Re: [SQL] plpgsql question