From: | "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar> |
---|---|
To: | "'Jorge Anibal Reyes Pineda'" <jorgeanibal1(at)hotmail(dot)com>, <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | RE: CREAR ARCHIVOS FORMATO.XLS PARA EXCEL O OPENORG |
Date: | 2009-09-10 22:21:18 |
Message-ID: | 3398918DB5894CFCAFD017377BB8F921@iptel.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
> -----Mensaje original-----
> De: Jorge Anibal Reyes Pineda
>
> Saludos..
> Una consulta..
> Existe alguna comando o funsion en pgsql que pueda leer datos
> de una tabla y crear un archivo en formato XLS PARA abrirlo
> desde excel o openorg
>
> Algun ejemplito o una pista de como lograr hacer eso.
>
pg=# \h copy
Command: COPY
Description: copy data between a file and a table
Syntax:
COPY tablename [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ HEADER ]
[ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE NOT NULL column [, ...] ]
COPY { tablename [ ( column [, ...] ) ] | ( query ) }
TO { 'filename' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ HEADER ]
[ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE QUOTE column [, ...] ]
Ejemplo:
pg=# copy mi_tabla to '/tmp/pepe.csv' WITH CSV HEADER FORCE QUOTE columna3;
Saludos.
From | Date | Subject | |
---|---|---|---|
Next Message | Calabaza | 2009-09-10 22:28:47 | Re: CREAR ARCHIVOS FORMATO.XLS PARA EXCEL O OPENORG |
Previous Message | Ernesto Quiñones | 2009-09-10 21:59:45 | Re: CREAR ARCHIVOS FORMATO.XLS PARA EXCEL O OPENORG |