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

[Joost Kraaijeveld <J.Kraaijeveld@xxxxxxxxxx>]

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 broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org