Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] equivalent of sqlload? - Mailing list pgsql-general

From Sferacarta Software
Subject Re: [GENERAL] equivalent of sqlload?
Date
Msg-id 13675.981125@bo.nettuno.it
Whole thread Raw
In response to equivalent of sqlload?  (John Holland <jholland@isr.umd.edu>)
List pgsql-general
Tree view 
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'-

pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] equivalent of sqlload?
Next
From: Byron Nikolaidis
Date:
Subject: Postgres mentioned in Information Week