Steve T wrote:
> I wasn't aware that you could!
> I just tried and that syntax gave me an error:
> *rel_reinsure=# copy (select * from client where name like '%BERT%') to
> '/tmp/stevet.clients';*
> *ERROR: syntax error at or near "(" at character 6*
> *LINE 1: copy (select * from client where name like '%BERT%') to '/tm...*
What version do you have? These three pages appear to have some
differences between 8.1 and 8.2:
http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
http://www.postgresql.org/docs/8.2/interactive/sql-copy.html
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html