> -----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.
--
TIP 4: No hagas 'kill -9' a postmaster
