On 2009-04-27, Preetam Palwe <preetamp(at)aftek(dot)com> wrote:
> This is a multi-part message in MIME format.
> 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=20
>
>
> insert into table2 (select * from table1)
>
>
> but the problem is how can I specify the database name?
you can't
you can do this however:
psql -c " copy (select * from table1) to stdout " database1 | psql -c " copy table2 from stdin " database2