| From: | "Leonel Nunez" <postgres(at)enelserver(dot)com> |
|---|---|
| To: | pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx |
| Subject: | Re: [Pgsql-ayuda] Ingreso Masivo de Datos |
| Date: | 2004-02-27 17:28:39 |
| Message-ID: | 33396.201.129.165.153.1077902919.squirrel@enelserver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
> Hola...
>
> Existe alguna forma de cargar masivamente datos dentro de las tablas de
> postgresql???. Algo similar a lo que se hace con MySql con "load data
> infile '/directorio/nombrearchivo' into table tabla", existe???
>
> Nuevo MSN Messenger Una forma rápida y divertida de enviar mensajes
> _______________________________________________
> Pgsql-ayuda mailing list
> Pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
> http://tlali.iztacala.unam.mx/mailman/listinfo/pgsql-ayuda
>
leonel=> \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' ] ]
COPY tablename [ ( column [, ...] ) ]
TO { 'filename' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ] ]
,''`. Leonel Nunez
: :' : http://enelserver.com
`. `' DEBIAN GNU/LINUX
`- A REAL FREE OS
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pablo P. | 2004-02-27 18:32:02 | [Pgsql-ayuda] Ingreso Masivo de Datos |
| Previous Message | al daniel | 2004-02-27 17:12:16 | [Pgsql-ayuda] Ayuda uso del LIKE en una funcion |