Re: Definging columns for INSERT statements

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

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