From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | John McKown <joarmc(at)swbell(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: copy table from one database to another |
Date: | 2000-09-20 22:18:19 |
Message-ID: | Pine.BSF.4.21.0009201815510.52955-100000@paprika.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 20 Sep 2000, John McKown wrote:
> Is there a simple way to copy a table from one database to another? I was
> totally restructuring the tables in a database, so I simply created a new
> database. There was one table in the old database whose information I
> wanted. I really wanted to copy the table from the old database to the new
> one and rename the table during the copy. What I ended up doing was using
> "pg_dump -t table olddb >old.info", then I editted the "old.info" file to
> point to the new database and renamed the table as well. I could then use
> the "\i old.info" command in psql to import the information. Is there a
> better without writing code in Perl or Python? (I.e. within psql).
What version of PostgreSQL are you using? I move tables around all the
time and don't need to edit. Instead of the \i, try this:
pg_dump -t table olddb > old.info
psql newdb < old.info
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Kientzle | 2000-09-20 22:45:39 | Re: Large Objects |
Previous Message | John McKown | 2000-09-20 21:38:55 | copy table from one database to another |