Postgres Insert row with only an auto increment column
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.