Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 29 Dec 2008 23:35:26 +0100
- Message-id: <495950AE.30005@lelarge.info> <text/plain>
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
- References:
- Copy question
- From: Judith Altamirano
- Copy question
- Prev by Date: Copy question
- Next by Date: Re: Object create date
- Previous by thread: Copy question
- Next by thread: Question on Escape-string
- Indexes: