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

From David Steuber
Subject Re: Importing into Postgres from a csv file
Date
Msg-id m3ya1nr9j3.fsf@solo.david-steuber.com
Whole thread Raw
In response to Importing into Postgres from a csv file  ("Jake" <ccrasoro@home.com>)
List pgsql-general
"Jake" <ccrasoro@home.com> writes:

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

With my present knowledge, I would either use a Perl script to create
a file that looks like the file you get when you dump a table, or I
would use the DBI/DBD::Pg modules to insert the rows, one by one.

The method I choose would depend on whether the data replaces the old
data or is added to it.

I just bought the "Programming the Perl DBI" book published by
O'Reilly, so needless to say, I am not quite ready to import a cvs
file yet.

--
David Steuber | "Are you now, or have you ever been, a member
NRA Member    | of the NRA?" --- HUAC, 2004

Happiness is a SAAB Gripen <http://www.gripen.saab.se/> in the
garage, an FN-FAL in the safe, and an HK P7M8 on the hip.

pgsql-general by date:

Previous
From: "Sherwin Daganato"
Date:
Subject: serial data type limit
Next
From: "anuj"
Date:
Subject: FW: Count & Distinct