Re: Definging columns for INSERT statements

On Wed, 12 Jun 2024, David G. Johnston wrote:

>> INSERT INTO people (person_nbr
>> DEFAULT('people_person_nbr_seq'),lname,fname,job_title DEFAULT
>> 'Contact',company_nbr,loc_nbr,direct_phone,cell_phone,email,active
>> DEFAULT('true')) VALUES
>>
>
> https://www.postgresql.org/docs/current/sql-insert.html
>
> Not sure where you got the idea that something besides a plain column name
> can appear in the optional parentheses after the table name.

David,

I've not used nextval() before which is why I asked.

Thanks,

Rich