| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | blackwater dev <blackwaterdev(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: insert multiple rows |
| Date: | 2005-10-31 23:50:34 |
| Message-ID: | 1130802633.15018.38.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2005-10-31 at 17:13, David Fetter wrote:
> 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).
Note that for complex schemas, prepared queries may also be a good
choice.
Symantically, the closest thing to this for postgresql is doing:
begin;
insert ...
insert ...
insert ...
commit;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Peter | 2005-11-01 00:37:39 | How may I keep prepended array items positive? |
| Previous Message | Rafael Montoya | 2005-10-31 23:33:47 | Re: after insert or update or delete of col2 |