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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Mon, 29 Dec 2008 16:28:19 -0600
  • Message-id: <49594F03.4080809@correolux.com.mx> <text/plain>

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?



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group