| From: | "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(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:50:56 |
| Message-ID: | 3F731CF0.2090800@sonalysts.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?
Assuming the CSV file data is well formed, use psql and
the COPY command.
In psql, create the table. Then issue command:
copy <tablename> from 'filename' using delimiters ',';
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-09-25 16:57:57 | Re: populate table with large csv file |
| Previous Message | Joe Conway | 2003-09-25 16:43:41 | Re: populate table with large csv file |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-09-25 16:57:57 | Re: populate table with large csv file |
| Previous Message | Joe Conway | 2003-09-25 16:43:41 | Re: populate table with large csv file |