Copy question

From: Judith Altamirano <jaltamirano(at)correolux(dot)com(dot)mx>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Copy question
Date: 2008-12-29 22:28:19
Message-ID: 49594F03.4080809@correolux.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Guillaume Lelarge 2008-12-29 22:35:26 Re: Copy question
Previous Message Alvaro Herrera 2008-12-29 21:39:16 Re: Object create date