Re: Postgresql bulk fast loader - Mailing list pgsql-hackers

From mlw
Subject Re: Postgresql bulk fast loader
Date
Msg-id 3B4BA0B1.2C20EF74@mohawksoft.com
Whole thread Raw
In response to Postgresql bulk fast loader  (Naomi Walker <nwalker@eldocomp.com>)
List pgsql-hackers
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
'nullstring' ]
 
COPY [ BINARY ] table [ WITH OIDS ]   TO { 'filename' | stdout }   [ [USING] DELIMITERS 'delimiter' ]   [ WITH NULL AS
'nullstring' ]
 


pgsql-hackers by date:

Previous
From: Naomi Walker
Date:
Subject: Postgresql bulk fast loader
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: SOMAXCONN (was Re: Solaris source code)