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?

Answer 1

According to INSERT syntax:

insert into books default values
returning id;

Answer 2

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