Postgres Pro
Downloads
Home   >   mailing lists

Re: multiple inserts - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: multiple inserts
Date
Msg-id 20050617135629.GB73152@winnie.fuhr.org
Whole thread Raw
In response to multiple inserts  ("Oren Mazor" <oren.mazor@gmail.com>)
List pgsql-novice
Tree view 
On Fri, Jun 17, 2005 at 09:32:21AM -0400, Oren Mazor wrote:
>
> I'm wondering if it is at all possible to do a mass insert into a table
> using only a single query?

See the COPY command:

http://www.postgresql.org/docs/8.0/static/sql-copy.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: Trigger and Trigger function.
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] multiple inserts