Re: Is there a utility to load data?

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