Re: Importing into Postgres from a csv file

Поиск
Список
Период
Сортировка
От David Steuber
Тема Re: Importing into Postgres from a csv file
Дата
Msg-id m3ya1nr9j3.fsf@solo.david-steuber.com
обсуждение исходный текст
Ответ на Importing into Postgres from a csv file  ("Jake" <ccrasoro@home.com>)
Список 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 по дате отправления:

Предыдущее
От: "Sherwin Daganato"
Дата:
Сообщение: serial data type limit
Следующее
От: "anuj"
Дата:
Сообщение: FW: Count & Distinct