Re: Blank SQL insert statements

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   peter_e@gmx.net   http://funkturm.homeip.net/~peter