Message-ID: <3B4C56F1.5B46F924@epa.gov>
Date: Wed, 11 Jul 2001 09:38:57 -0400
From: Mark Volpe <volpe.mark@epa.gov>
MIME-Version: 1.0
To: mlw <markw@mohawksoft.com>
CC: Naomi Walker <nwalker@eldocomp.com>,
	PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: Postgresql bulk fast loader
References: <4.2.2.20010710170412.00a99820@logic1design.com>
	<3B4BA0B1.2C20EF74@mohawksoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Avoid doing this with indexes on the table, though. I learned the hard way!

Mark

mlw wrote:
> 
> Naomi Walker wrote:
> >
> > Does postgresql have any sort of fast bulk loader?
> 
> It has a very cool SQL extension called COPY. Super fast.
> 
> Command:     COPY
> Description: Copies data between files and tables
> Syntax:
> COPY [ BINARY ] table [ WITH OIDS ]
>     FROM { 'filename' | stdin }
>     [ [USING] DELIMITERS 'delimiter' ]
>     [ WITH NULL AS 'null string' ]
> COPY [ BINARY ] table [ WITH OIDS ]
>     TO { 'filename' | stdout }
>     [ [USING] DELIMITERS 'delimiter' ]
>     [ WITH NULL AS 'null string' ]
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org