Re: Copy question

Judith Altamirano a écrit :
> Hello every body I'm trying to extract a query as follows:
>
> copy (select * from clientes where id_cliente = 7895) to
> '/home/paso/sel.copy';
>
> But it returns the next error:
>
> ERROR: error de sintaxis en o cerca de «(» at character 6
> LINE 1: copy (select * from clientes where id_cliente = 7895) to '/h...
>
>
> I was reading the manual and I think the sintaxis is correct, any idea
> wich is the cause of the error?
>

It depends on your PostgreSQL release. It should work with 8.2 and
later. It won't with earlier releases.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com