The COPY .... TO filename doesnt seem to work.
Copying a table works OK. If Copy from a view isnt allowed how can I get
the results of a query into an external file?
Example:
=> \d top_hits
View = top_hits
Query = SELECT "company"."name", "co_hits"."hits" FROM "company",
"co_hits" WHERE ("co_hits"."number" = "company"."number");
=>copy top_hits to STDOUT;
Copy command returns...
Thanks
Steve
--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk