Re: Text Import

Поиск
Список
Период
Сортировка
От Jason Earl
Тема Re: Text Import
Дата
Msg-id 20010822235237.56108.qmail@web10008.mail.yahoo.com
обсуждение исходный текст
Ответ на Text Import  (Pete Poggione <ppoggione@ebsllc.com>)
Список pgsql-novice
You are probably going to have to script the import (I
like Python for this, but Perl is probably the most
popular tool for this type of thing).

You might try importing your data into Gnumeric (or
Excel I suppose), and then exporting it as a delimited
file, if your data file isn't too terribly big (less
than 65K lines).

If you need some help cooking something up I would be
happy to give you a hand.

Jason


--- Pete Poggione <ppoggione@ebsllc.com> wrote:
> Does anyone know where I can find some good
> documentation on importing a
> fixed record length text file into a postgresql
> table? I find lots of
> information for importing delimited files.
>
> Thanks,
> Pete
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

В списке pgsql-novice по дате отправления:

Предыдущее
От: Murray Hobbs
Дата:
Сообщение: protected ON DELETE CASCADE
Следующее
От: Bo Lorentsen
Дата:
Сообщение: integrity and inherit