how do i insert a default value?

On Tue, 12 Nov 2002, Andy Kriger wrote:

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?

Postgresql uses the keyword DEFAULT with no ticks to get a default.

insert into table bubba values ('truck','washer',DEFAULT,'gun
rack',DEFAULT,36,24,36);

"scott.marlowe" <scott.marlowe@ihs.com> writes:

On Tue, 12 Nov 2002, Andy Kriger wrote:

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.

Postgresql uses the keyword DEFAULT with no ticks to get a default.

insert into table bubba values ('truck','washer',DEFAULT,'gun
rack',DEFAULT,36,24,36);

That's new in 7.3, though. In prior releases you could only (a) omit
columns at the right, or (b) use a column name list.

regards, tom lane

On Tue, 12 Nov 2002, Tom Lane wrote:

"scott.marlowe" <scott.marlowe@ihs.com> writes:

On Tue, 12 Nov 2002, Andy Kriger wrote:

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.

Postgresql uses the keyword DEFAULT with no ticks to get a default.

insert into table bubba values ('truck','washer',DEFAULT,'gun
rack',DEFAULT,36,24,36);

That's new in 7.3, though. In prior releases you could only (a) omit
columns at the right, or (b) use a column name list.

Yeah, I realized that RIGHT after I'd written my second response. sigh