Re: [GENERAL] equivalent of sqlload?

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-general(at)postgresql(dot)org, John Holland <jholland(at)isr(dot)umd(dot)edu>
Subject: Re: [GENERAL] equivalent of sqlload?
Date: 1998-11-25 15:13:18
Message-ID: 13675.981125@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello John,

mercoledì, 25 novembre 98, you wrote:

JH> Oracle has a facility for loading in massive data files, sqlload I think
JH> is the name. I'd like to load some big data into PostgreSQL 6.4 for
JH> testing purposes. Is there a way built in or would a perl or c hack be the
JH> way to go?

JH> john holland

use:
copy [binary] classname [with oids]
to|from 'filename'|stdin|stdout
[using delimiters 'delim']

or:
\copy classname from filename

-Jose'-

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1998-11-25 15:28:24 Re: [GENERAL] equivalent of sqlload?
Previous Message John Holland 1998-11-25 14:45:34 equivalent of sqlload?