How do I create a new row with all default values in Postgres?

Question

I have a table with two columns, id and created. Both have default values, so I should be able to insert a new row without supplying any data.

However, this syntax does not work:

INSERT INTO books () VALUES ()

I would also like to return the generated id of the inserted row. This syntax also does not work:

INSERT INTO books () VALUES () RETURNING id

How do I write this query in Postgres SQL?

klin · Accepted Answer · 2017-11-28 14:28:17Z

13

According to INSERT syntax:

insert into books default values
returning id;

answered Nov 28, 2017 at 14:28

klin

123k15 gold badges240 silver badges262 bronze badges

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

Comments

Vao Tsun · Accepted Answer · 2017-11-28 14:29:52Z

3

here is example (basically, just use DEFAULT):

t=# create table d(i int default 0, t text default 'a');
CREATE TABLE
t=# insert into d values(DEFAULT,DEFAULT) returning *;
 i | t
---+---
 0 | a
(1 row)

INSERT 0 1

edited Nov 28, 2017 at 14:29

answered Nov 28, 2017 at 14:25

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

1 Comment

sdgfsdh Over a year ago

Is there a way to specify all values as DEFAULT in one expression?

Collectives™ on Stack Overflow

How do I create a new row with all default values in Postgres?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related