how do i insert a default value? - Mailing list pgsql-general

From Andy Kriger
Subject how do i insert a default value?
Date
Msg-id OJEFIHHAALOBKKJEOMBDGEBMCHAA.akriger@greaterthanone.com
Whole thread Raw
Responses Re: how do i insert a default value?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
How do you insert a default value in an insert statement that doesn't
specify column names? For example, I have a table with 20 columns. I don't
want to specify the names in order to skip columns that have default values.

In MySql a null or empty value uses the default column value. In Postgres?

thx
andy



pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Win2K Questions
Next
From: "scott.marlowe"
Date:
Subject: Re: Upgrading from 7.1.3 to 7.2.3