On 2009-04-28, Preetam Palwe <preetamp(at)aftek(dot)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.