Re: insert multiple rows

From: David Fetter <david(at)fetter(dot)org>
To: blackwater dev <blackwaterdev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: insert multiple rows
Date: 2005-10-31 23:13:16
Message-ID: 20051031231316.GA11118@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 31, 2005 at 06:06:14PM -0500, blackwater dev 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?

The similar thing in PostgreSQL is the COPY command (man 8 copy).

HTH :)

Cheers,
David.
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2005-10-31 23:22:23 Re: Installation trouble
Previous Message blackwater dev 2005-10-31 23:06:14 insert multiple rows