Alvaro Herrera escreveu:
test tester escribió:
On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
i have version 8.1 and i want to know how to insert multiple rows in this
version.
Upgrade.
Use COPY instead.
Put you data into a var, and perf
test tester escribió:
> On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
>
> > i have version 8.1 and i want to know how to insert multiple rows in this
> > version.
Upgrade.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt,
am Thu, dem 04.10.2007, um 18:47:01 +0500 mailte test tester folgendes:
>
>
> On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
>
> i have version 8.1 and i want to know how to insert multiple rows in this
> version.
Please no silly top post.
You can insert multiple values with one i
> On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
> > i have version 8.1 and i want to know how to insert multiple rows in this
> version.
Please don't top post.
If you need this functionality, you should really upgrade.
In cases where you want to insert multiple rows in version 8.1, you
coul
On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
>
> i have version 8.1 and i want to know how to insert multiple rows in this
> version.
>
> On 10/4/07, Ashish Karalkar < [EMAIL PROTECTED]> wrote:
> >
> > INSERT INTO qsweb.core_board(board_name, entry_user_id, entry_date)
> > VALUES ('a',1,
INSERT INTO qsweb.core_board(board_name, entry_user_id, entry_date)
VALUES ('a',1,now()),('b',1,now());
- Original Message -
From: test tester
To: pgsql-general@postgresql.org
Sent: Thursday, October 04, 2007 4:49 PM
Subject: [GENERAL] multiple row insertion
In MySQL, I
On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
>
> In MySQL, I can insert multiple rows like this:
>
>
> insert into cars values(5, "toyota"),(5,"ford"), etc.
>
>
> How can I do something similiar in PostgreSQL?
>
>
Exactly the same way. Make sure though that your pgsql is new enough version
(8
