Thread: Is there a utility to load data?

Is there a utility to load data?

From
Pam Wampler
Date:
Is there a postgresql utility to load data from a flat file?  Similar to
oracle sqlldr?

Re: Is there a utility to load data?

From
Chris Ruprecht
Date:
Pam,

I use the psql 'copy' function like this:

copy <tablename> from '<file name>' delimiters ',';

Best regards,
Chris

At 14:00 -0500 02/13/2002, 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


--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


Re: Is there a utility to load data?

From
Jeff Self
Date:
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