Re: Copy question - Mailing list pgsql-sql

From Guillaume Lelarge
Subject Re: Copy question
Date
Msg-id 495950AE.30005@lelarge.info
Whole thread Raw
In response to Copy question  (Judith Altamirano <jaltamirano@correolux.com.mx>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Judith Altamirano
Date:
Subject: Copy question
Next
From: "Fernando Hevia"
Date:
Subject: Re: Object create date