Re: php to import csv to postgres - Mailing list pgsql-general

From Chris
Subject Re: php to import csv to postgres
Date
Msg-id 443595D6.4050902@gmail.com
Whole thread Raw
In response to php to import csv to postgres  (SunWuKung <Balazs.Klein@axelero.hu>)
Responses Re: php to import csv to postgres  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
SunWuKung wrote:
> I am not sure I should be posting this here, but I guess you are the
> people most likely be able to answer this.
>
> I have been looking for a user friendly php script to import csv into
> Postgres (set separator, preview data, match columns - or any of these).
> I found many for MySQL but  none that would work with Postgres.
>
> Maybe somebody could direct me to such a script.

Copy might be able to do it for you:

http://www.postgresql.org/docs/8.1/interactive/sql-copy.html

use ',' as the delimiter.

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: Guy Fraser
Date:
Subject: Re: Backup method
Next
From: Scott Marlowe
Date:
Subject: Re: php to import csv to postgres