| From: | Doug Bloebaum <blabes(at)gmail(dot)com> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | robert(at)webtent(dot)com, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Create a pg table from CSV with header rows |
| Date: | 2005-09-16 14:41:59 |
| Message-ID: | caa2de8a0509160741776f5f45@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9/15/05, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> On Thu, Sep 15, 2005 at 06:48:59PM -0400, Robert Fitzpatrick wrote:
> > Anyone know a package that can do this? Perferrably a Unix/Linux
> > package.
>
> It would be trivial to write a script in a language like Perl to
> read the first line of a file and generate a CREATE TABLE statement
> from it, then issue a COPY command and send the rest of the file.
> Determining the columns' data types would be a different matter:
> if they weren't specified in the header then you'd have to guess
> or perhaps make them all text.
I've attached a sample implementation of Michael's suggestion.
| Attachment | Content-Type | Size |
|---|---|---|
| loadCsv2.pl | application/octet-stream | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-09-16 14:45:57 | Re: Question about a query plan |
| Previous Message | Tom Lane | 2005-09-16 14:25:12 | Re: Strange Bug in exim4 postgresql lookup code or libpq? |