Re: export data from excel to postges - Mailing list pgsql-admin

From Geoffrey
Subject Re: export data from excel to postges
Date
Msg-id 3F717145.9040804@3times25.net
Whole thread Raw
In response to Re: export data from excel to postges  (Ge'mes Ge'za <geza@kzsdabas.sulinet.hu>)
List pgsql-admin
THere are perl modules to export excel.  I've never used them, can't
vouch for their accuracy.  That said, perl could do your export and
input to the db via dbi/dbd.


Ge'mes Ge'za wrote:
> Lee Weaver i'rta:
>
>
>>Could someone please tell me where I could find info on exporting
>>excel data into postgresql, or how to do it. Thanks!
>
>
> Try to save your data from excel in csv format and then use a _COPY_ to
> load it to a _previously created table_._
>
> _Good Luck!
>
> Geza Gemes_
> _
>

--
Until later, Geoffrey    esoteric@3times25.net

Building secure systems inspite of Microsoft


pgsql-admin by date:

Previous
From: Hornyak Laszlo
Date:
Subject: Re: postgres 6.2 vacuum
Next
From: "pierre bach"
Date:
Subject: vacuum failed - pgtoast not btree