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 "
> 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.
In response to
pgsql-novice by date
|Next:||From: Marcin Krol||Date: 2009-04-29 12:37:50|
|Subject: retrieving primary key for row with MIN function|
|Previous:||From: Neil Saunders||Date: 2009-04-28 16:55:30|
|Subject: Re: Query appears not to recognise index (enable_seqscan=off)|