Re: Insert into a table with only a SERIAL - Mailing list pgsql-general

<felix@crowfix.com> writes:
> I can't insert into aaa unless I pass a value; these don't work:

>   insert into aaa;
>   insert into aaa values ();
>   insert into aaa () values ();

"INSERT INTO aaa DEFAULT VALUES" is the SQL-approved verbiage.

(Hey, I didn't design this language ;-))

            regards, tom lane