Thread: Copy question

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?

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.orghttp://dalibo.com