Re: [LUG] Importing CSV files into postgres

[Roland Tarver <roland.tarver@xxxxxxxxxxxxxxx>]

I only need something very simple, can I import from csv in psql using 
some sql statements?

i only need to do this once.

thanks a lot for your help
best wishes
roland

Kai Hendry wrote:

> There is a zillion (best) ways of doing this of course.
>
> I would load up my brand new Python2.3 Beta with:
> http://www.python.org/dev/doc/devel/lib/module-csv.html
> and some Postgres DBM module. 
> apt-cache search python postgres
> Seems to be a few. This one looks good:
> http://pypgsql.sourceforge.net/
>
> And get to work.
>
> -Kai
>
> On Mon, May 12, 2003 at 09:38:41 +0100, Roland Tarver wrote:
>  
>
> > I've got a small open office calc sheet, that I've saved as a CSV file.
> > I now need to import it into postgres? What's the best way of doing this?
> >    
>
> --
> The Mailing List for the Devon & Cornwall LUG
> Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the
> message body to unsubscribe.
>
>
> ******************************************************************************
> This email has been virus checked by the Eclipse Internet MAILsafe service
> ******************************************************************************
> www: http://www.eclipse.net.uk/                email: eclipse@xxxxxxxxxxxxxx 
> ******************************************************************************
>
>  


--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe.