Skip site navigation (1) Skip section navigation (2)

Re: Flat File unload/export/copy

From: Frank Bax <fbax(at)sympatico(dot)ca>
To:
Cc: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Flat File unload/export/copy
Date: 2008-09-12 17:11:03
Message-ID: 48CAA2A7.1020504@sympatico.ca (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-novice by date

Next:From: Steve TDate: 2008-09-12 17:14:42
Subject: Re: Flat File unload/export/copy
Previous:From: Steve TDate: 2008-09-12 16:10:17
Subject: Re: Flat File unload/export/copy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group