By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

COPY Query fails in postgre release 8.2

P: 1
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
Sep 6 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.