Re: php to import csv to postgres

From: Chris <dmagick(at)gmail(dot)com>
To: SunWuKung <Balazs(dot)Klein(at)axelero(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: php to import csv to postgres
Date: 2006-04-06 22:27:34
Message-ID: 443595D6.4050902@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-04-06 23:52:02 Re: php to import csv to postgres
Previous Message Guy Fraser 2006-04-06 22:24:49 Re: Backup method