Thread: how do i insert a default value?
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
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