COPY to

Hi Pgsql,

I want to copy the output of a SELECT query onto a text file. I'm trying to use the COPY command for that as :

COPY (SELECT .... ) to 'outfile'

But its throwing some error. Is it possible? Else, are there any means to do it?

Thanks,
AK

--
Ignore the impossible but honor it ...
The only enviable second position is success, since failure always comes first...