Postgres Insert row with only an auto increment column
Jun 3, 2015
1 minute read

How do you insert a record into a postgres table that has a single auto incrementing primary key field? There weren’t many hits on google with the solution, so hopefully this helps someone else:

INSERT INTO [table] (id) values (default);

I originally tried using null and 0 as the values, but null throws a primary key constraint error and 0 actually gets inserted as 0.