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).
Thanks,
John