Postgres Pro
Downloads
Home   >   mailing lists

RE: Importing into Postgres from a csv file - Mailing list pgsql-general

From Rafa Couto
Subject RE: Importing into Postgres from a csv file
Date
Msg-id 007601c00da2$63713340$8802a8c0@ct.priv
Whole thread Raw
In response to Importing into Postgres from a csv file  ("Jake" <ccrasoro@home.com>)
List pgsql-general
Tree view 
----- Mensaje original -----
De: "Jake" <ccrasoro@home.com>
Para: <pgsql-general@postgresql.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'
  ;

pgsql-general by date:

Previous
From: Gilles DAROLD
Date:
Subject: Re: 2-phase commit
Next
From: "Jackson Ching"
Date:
Subject: JDBC