John Poltorak wrote:
> Is there a simple way to import a CSV file into a Postgres database?
If it is a simple CSV file then you should be able to manage with the
COPY command, using appropriate values for DELIMITERS.
If your CSV file has text quoted, and which includes line breaks within
fields, then you need to get more complex.
I have a perl script you can use in this case, if you want.
Andrew McMillan, e-mail: Andrew(at)catalyst(dot)net(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
In response to
pgsql-novice by date
|Next:||From: John Poltorak||Date: 2001-01-15 18:19:39|
|Subject: Re: Importing CSV file|
|Previous:||From: Petros Mylonopoulos||Date: 2001-01-15 16:31:42|
|Subject: Re: Too many open connections|