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: | Raw Message | Whole Thread | 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 |