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 a
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
On Wed, 20 Sep 2000, Vince Vielhaber wrote:
> On Wed, 20 Sep 2000, John McKown wrote:
>
> 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
I'm ru