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

On 2009-04-28, Preetam Palwe <preetamp@aftek.com> wrote:
> Thanks folks!
> Following command worked for me
>
>
> psql -h x.x.x.x -U postgres -d securez -c " copy  alerts to stdout "  |
> psql -h x.x.x.x -U postgres -d p -c " copy alerts from stdin "
>
> but
> psql -h x.x.x.x -U postgres -d securez -c " copy (select * from alerts)
> to stdout "  | psql -h x.x.x.x -U postgres -d p -c " copy alerts from
> stdin "
>
> is giving me syntax error as
>
> ERROR:  syntax error at or near "("
> LINE 1:  copy (select * from alerts) to stdout
>
> Any idea ?

That syntax needs version 8.3, I usually do it that way, but with a where
clause in the select as most times I don't want the whole table.