Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group