From: mlw <markw@mohawksoft.com>
To: Naomi Walker <nwalker@eldocomp.com>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: Postgresql bulk fast loader
Date: Tue, 10 Jul 2001 20:41:21 -0400
Message-ID: <3B4BA0B1.2C20EF74@mohawksoft.com> (raw)
References: <4.2.2.20010710170412.00a99820@logic1design.com>
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' ]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: markw@mohawksoft.com, nwalker@eldocomp.com
Subject: Re: Postgresql bulk fast loader
In-Reply-To: <3B4BA0B1.2C20EF74@mohawksoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox