From: | Mark Volpe <volpe(dot)mark(at)epa(dot)gov> |
---|---|
To: | mlw <markw(at)mohawksoft(dot)com> |
Cc: | Naomi Walker <nwalker(at)eldocomp(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Postgresql bulk fast loader |
Date: | 2001-07-11 13:38:57 |
Message-ID: | 3B4C56F1.5B46F924@epa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2001-07-11 13:56:27 | Re: varchar vs. text |
Previous Message | Tony Grant | 2001-07-11 13:06:57 | JDBC and stored procedures |