Re: Is there a utility to load data?

Поиск
Список
Период
Сортировка
От Jeff Self
Тема Re: Is there a utility to load data?
Дата
Msg-id 1013630536.4343.6.camel@personnel_test
обсуждение исходный текст
Ответ на Is there a utility to load data?  (Pam Wampler <Pam_Wampler@taylorwhite.com>)
Список pgsql-admin
pg_restore or copy. look in the documentation.

I import data from flat files usually this way:

psql dbname < file

The file contains a line before the data:

COPY "tablename" FROM stdin;
data....
\.

If your delimiter is something other than tab you must specify the
delimiter type this way:

COPY "tablename" FROM stdin USING DELIMITERS '|'; # this is using | as
the delimiter.
On Wed, 2002-02-13 at 14:00, Pam Wampler wrote:
> Is there a postgresql utility to load data from a flat file?  Similar to
> oracle sqlldr?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930


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

Предыдущее
От: Chris Ruprecht
Дата:
Сообщение: Re: Is there a utility to load data?
Следующее
От: dalgoda@ix.netcom.com (Mike Castle)
Дата:
Сообщение: Re: restore whoes