On 12:00 pm 07/23/08 Shane Ambler <pgsql@xxxxxxxxxx> wrote: > > INSERT INTO table (fld_y,fld_z) VALUES ('y','z') I believe that is the most common way of doing it. > > which is really doing: > > INSERT INTO table (fld_x, fld_y,fld_z) VALUES (DEFAULT, 'y','z') Correct. So either one should be fine.