Re: php to import csv to postgres

Поиск
Список
Период
Сортировка
От Chris
Тема Re: php to import csv to postgres
Дата
Msg-id 443595D6.4050902@gmail.com
обсуждение исходный текст
Ответ на php to import csv to postgres  (SunWuKung <Balazs.Klein@axelero.hu>)
Ответы Re: php to import csv to postgres  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список 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 по дате отправления:

Предыдущее
От: Guy Fraser
Дата:
Сообщение: Re: Backup method
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: php to import csv to postgres