Initializing Row with Default Values

Question

I have a table. This table has no rows in it currently and every column has some sort of default value.

I do not wish to actually insert any data, but I want 1 row to appear with all of the default values. How do I do this? This does not work:

insert into testing.constants values defaults;

Gordon Linoff · Accepted Answer · 2016-10-20 02:16:52Z

1

I think the syntax is default values:

insert into testing.constants default values;

You might be confused with setting a default for one particular column. For instance:

insert into testing.constants(col1, col2)
    values (default, default);

answered Oct 20, 2016 at 2:16

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

That's what it was. Darn. Thanks Gordon!