| 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: | 20050617140218.GA5880@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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 http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark J. Bailey | 2005-06-17 14:04:32 | Storing an array to Postgresql table |
| Previous Message | Michael Fuhr | 2005-06-17 13:56:29 | Re: multiple inserts |