PostgreSQL Discussion - Re: How do I copy part of table from db1 to db2 (and rename the columns)?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Roman Neuhauser

2005-08-31, 7:24 am

# J.Kraaijeveld@Askesis.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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links