RE: Importing into Postgres from a csv file

From: "Rafa Couto" <rcouto(at)pascualsilva(dot)com>
To: "Jake" <ccrasoro(at)home(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: RE: Importing into Postgres from a csv file
Date: 2000-08-24 08:07:46
Message-ID: 007601c00da2$63713340$8802a8c0@ct.priv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


----- Mensaje original -----
De: "Jake" <ccrasoro(at)home(dot)com>
Para: <pgsql-general(at)postgresql(dot)org>
Enviado: miércoles, 23 de agosto de 2000 21:56
Asunto: [GENERAL] Importing into Postgres from a csv file

> Does any one know if this is possible, and if so how?

Use copy command:

COPY table FROM 'data.csv'
USING DELIMITERS ','
WITH NULL AS 'null string'
;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Janne Blomqvist 2000-08-24 10:53:42 VS: JDBC
Previous Message netvigator 2000-08-24 08:05:47 psqlODBC