| From: | "Rodger Donaldson" <rodgerd(at)diaspora(dot)gen(dot)nz> |
|---|---|
| To: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>, Oliver Vecernik <vecernik(at)aon(dot)at>, pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: CSV import |
| Date: | 2003-01-29 03:13:36 |
| Message-ID: | E18difQ-0004mk-00@israel.diaspora.gen.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> --- Oliver Vecernik <vecernik(at)aon(dot)at> wrote:
> > Is there a direct way to import such files into
> > PostgreSQL?
> >
>
> As I believe others have replied: no, not yet.
>
> Otherwise, parsing CSV
> files gets just too complicated, and you are better
> off using an existing solution (like a Perl module) to
> preprocess your data.
The DBD::CSV module allows one to use a subset of SQL syntax on CSV
files, as an example. Docs are at
http://search.cpan.org/author/JZUCKER/DBD-CSV-0.2002/lib/DBD/CSV.pm
--
Rodger Donaldson
rodgerd(at)diaspora(dot)gen(dot)nz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-29 04:08:16 | Re: LONG - Question on dealing w/ numerics |
| Previous Message | Josh Berkus | 2003-01-29 02:54:11 | Re: LONG - Question on dealing w/ numerics |