COPY Query fails in postgre release 8.2

dheeru123

Newbie

Join Date: Sep 2007

Posts: 1

#1: Sep 6 '07

Hi folks,

I am trying to use copy command as follows:

COPY (SELECT * FROM table) TO '/usr/tmp/file.txt';

I get an error:

ERROR: syntax error at or near "(" at character 6

Have tried almost all forums and didn't get any resolution...Any help would be highly appreciated.

Many thanks in advance,

Dheeraj

« previous question | next question »

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

COPY Query fails in postgre release 8.2

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about