Skip site navigation (1) Skip section navigation (2)

Re: [despammed] multiple inserts

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [despammed] multiple inserts
Date: 2005-06-17 14:02:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
am  17.06.2005, um  9:32:21 -0400 mailte Oren Mazor folgendes:
> hi all,
> I'm wondering if it is at all possible to do a mass insert into a table  
> using only a single query?
> Something along the lines of:
> insert into mytable values (val1), (val2), (val3)

What do you mean, multiple rows, ore one row?
You can insert one row with any columns with "insert into table (col1, col2,
col3) values (val1, val2, val3);", and you can do a mass-insert with
"copy from ...".

Regards, Andreas
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C
 ===    Schollglas Unternehmensgruppe    === 

In response to

pgsql-novice by date

Next:From: Mark J. BaileyDate: 2005-06-17 14:04:32
Subject: Storing an array to Postgresql table
Previous:From: Michael FuhrDate: 2005-06-17 13:56:29
Subject: Re: multiple inserts

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group