Re: Flat File unload/export/copy - Mailing list pgsql-novice

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