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

Hi, 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... TIA Joost ---(end of

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

# [EMAIL PROTECTED] / 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...