#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 1999
    Location
    Annapolis, Maryland US
    Posts
    113
    Rep Power
    15

    Multiple inserts in one statement


    Given a simple table (called simple_table)

    id int
    name varchar
    state char

    in MySQL, you can use INSERT INTO simple_table(id, name) VALUES (1, 'Fred'), (2, 'John'), (3, 'Mary')......

    ...etc to add multiple entries with one statement.

    Is there a comparable way to do this in Postgres? The above syntax doesn't seem to work (Postgres 7.1.2)

    Any takers?

    Kyuzo
  2. #2
  3. #3
  4. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    114
    Rep Power
    15
    So, the answer is no, but you probably shouldn't do that anyway since its a non-standard extension that MySQL provides.

IMN logo majestic logo threadwatch logo seochat tools logo