Re: [GENERAL] equivalent of sqlload?

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: John Holland <jholland(at)isr(dot)umd(dot)edu>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] equivalent of sqlload?
Date: 1998-11-25 15:28:24
Message-ID: l03110703b281d221e93e@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 16:45 +0200 on 25/11/98, John Holland wrote:

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

Use the COPY command. It is preferable not to define indices (or to drop
the indices) on the table, then do the massive load with COPY, and then
define the indices.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Byron Nikolaidis 1998-11-25 15:42:29 Postgres mentioned in Information Week
Previous Message Sferacarta Software 1998-11-25 15:13:18 Re: [GENERAL] equivalent of sqlload?