Skip site navigation (1) Skip section navigation (2)

Re: Copy question

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Judith Altamirano <jaltamirano(at)correolux(dot)com(dot)mx>
Cc: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Copy question
Date: 2008-12-29 22:35:26
Message-ID: 495950AE.30005@lelarge.info (view raw or flat)
Thread:
Lists: 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.org
 http://dalibo.com

In response to

pgsql-sql by date

Next:From: Fernando HeviaDate: 2008-12-30 12:36:02
Subject: Re: Object create date
Previous:From: Judith AltamiranoDate: 2008-12-29 22:28:19
Subject: Copy question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group