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 do this however:
psql -c " copy (select * from table1) to stdout " database1 | psql -c " copy table2 from stdin " database2
In response to
pgsql-novice by date
|Next:||From: Preetam Palwe||Date: 2009-04-28 13:55:58|
|Subject: Re: Re: Copying data from one table of one database to other table f other database|
|Previous:||From: Dickson S. Guedes||Date: 2009-04-27 22:56:38|
|Subject: Re: [NOVICE] Workaround for bug #4608?|