Received: from snoopy.mohawksoft.com ([216.41.12.227])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6B0aXa19764
	for <pgsql-hackers@postgresql.org>;
	Tue, 10 Jul 2001 20:36:33 -0400 (EDT)
	(envelope-from markw@mohawksoft.com)
Received: from mohawksoft.com (IDENT:markw@localhost.localdomain [127.0.0.1])
	by snoopy.mohawksoft.com (8.11.0/8.11.0) with ESMTP id f6B0fM417100;
	Tue, 10 Jul 2001 20:41:22 -0400
Message-ID: <3B4BA0B1.2C20EF74@mohawksoft.com>
Date: Tue, 10 Jul 2001 20:41:21 -0400
From: mlw <markw@mohawksoft.com>
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.5-mohawk-smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Naomi Walker <nwalker@eldocomp.com>
CC: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: Postgresql bulk fast loader
References: <4.2.2.20010710170412.00a99820@logic1design.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200107/252
X-Sequence-Number: 10990

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' ]