Re: populate table with large csv file

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Dave [Hawk-Systems]" <dave(at)hawk-systems(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: populate table with large csv file
Date: 2003-09-25 16:43:41
Message-ID: 3F731B3D.1030003@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Dave [Hawk-Systems] wrote:
> aside from parsing the csv file through a PHP interface, what isthe easiest way
> to get that csv data importted into the postgres database. thoughts?
>

see COPY:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-copy.html

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message P.J. "Josh" Rovero 2003-09-25 16:50:56 Re: populate table with large csv file
Previous Message Dave [Hawk-Systems] 2003-09-25 16:38:07 populate table with large csv file

Browse pgsql-performance by date

  From Date Subject
Next Message P.J. "Josh" Rovero 2003-09-25 16:50:56 Re: populate table with large csv file
Previous Message Dave [Hawk-Systems] 2003-09-25 16:38:07 populate table with large csv file