Copying data from one table of one database to other table f other database - Mailing list pgsql-novice

Hello all

                I want to copy the data from one table to other table. These tables reside in two different databases.

I am thinking of using following query

insert into table2 (select * from table1)

but the problem is how can I specify the database name?

thanks for the help

~PP