Ashley @ Turton writes:

> Is it possible in PostgreSQL to construct a blank record without
> specifying a list of fields and values in an INSERT statement (so I
> can perform a collection for UPDATEs to populate the blank record)?

INSERT INTO tablename DEFAULT VALUES;

(The default values are going to be NULL unless you specified something
else when you created the table.)

-- 
Peter Eisentraut   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to