how do i insert a default value?

From: "Andy Kriger" <akriger(at)greaterthanone(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: how do i insert a default value?
Date: 2002-11-12 16:35:46
Message-ID: OJEFIHHAALOBKKJEOMBDGEBMCHAA.akriger@greaterthanone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2002-11-12 17:07:42 Re: RE : Stability problems
Previous Message Jean-Luc Lachance 2002-11-12 16:05:23 Re: Win2K Questions