Re: Definging columns for INSERT statements

[Rich Shepard]

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