Importing undelimited files (Flat Files or Fixed-Length records)

Поиск
Список
Период
Сортировка
От Bill Thoen
Тема Importing undelimited files (Flat Files or Fixed-Length records)
Дата
Msg-id 485AE3AA.3030700@gisnet.com
обсуждение исходный текст
Ответы Re: Importing undelimited files (Flat Files or Fixed-Length records)  ("Douglas McNaught" <doug@mcnaught.org>)
Re: Importing undelimited files (Flat Files or Fixed-Length records)  (Adrian Klaver <aklaver@comcast.net>)
Список pgsql-general
I've got to load some large fixed-legnth ASCII records into PG and I was
wondering how this is done. The Copy command looks like it works only
with delimited files, and I would hate to have to convert these files to
INSERT-type SQL to run them through psql.. Is there a way one can
specify a table structure with raw field widths and then just pass it a
flat file?


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Losing data
Следующее
От: "David Spadea"
Дата:
Сообщение: Re: renumber table