Re: Blank SQL insert statements - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Blank SQL insert statements
Date
Msg-id Pine.LNX.4.30.0110172024080.628-100000@peter.localdomain
Whole thread Raw
In response to Blank SQL insert statements  ("Ashley @ Turton" <ashley@turton.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Arcady Genkin
Date:
Subject: SQL equivallent to "\ds" in psql
Next
From: "Mitch Vincent"
Date:
Subject: Re: SQL equivallent to "\ds" in psql