Received: from exchange.bilgi.edu.tr (prol800.ibun.edu.tr [194.27.149.22]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA59325 for ; Tue, 16 May 2000 03:01:01 -0400 (EDT) (envelope-from eroloz@bilgi.edu.tr) Received: from bilgi.edu.tr (AKA610 [10.0.10.14]) by exchange.bilgi.edu.tr with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id KXW5YSQB; Tue, 16 May 2000 09:56:39 +0300 Message-ID: <3920F165.ACC31BF6@bilgi.edu.tr> Date: Tue, 16 May 2000 09:57:41 +0300 From: Erol Oz X-Mailer: Mozilla 4.72 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Re: is multiple insert possible with posgress? References: <20000515203921.B230@3eye.boxsoft.com> Content-Type: text/plain; charset=iso-8859-9 Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/6 Hi, I think there is no need multiple inserts. Because you can use copy command to insert hunderds of records from a delimited text file. It is much more easy to create a text file than to type hunderds of VALUES (...) lines in psql. Erol sidster wrote: > Greetings friends, > > I've started to look at postgreSQL for a potential rdbms platform to > move our development to. However, i have found one slight short-coming > thus far. > > I seems that multiple inserts are not supported by postgres: > > e.g., > > INSERT INTO test VALUES ( > 'one', 1, 2, 3 > ), ( > 'two', 2, 3, 4 > ), ( > . > . -- you get the idea > . -- now imagine a hundred or so of these > ), ( > 'ten', 10, 11, 12 > ); > > will generate the following error: > > ERROR: parser: parse error at or near "," > > Is this type of insert not supported at all? > > I did a search through the mailing lists (namely pgsql-sql and > pgsql-general). Admittedly the search wasn't exhaustive but i was > unable to 'hit' on any relevant topic. > > Could someone please clarify whether or not multiple-inserts are planned > for a near-future release? Pointers to documentation and/or > mailing-list discussions would be appreciated. > > tia, > > patrick > -- > Abstainer: a weak person who yields to the temptation of > denying himself a pleasure. > -- Ambrose Bierce