Home > mailing lists

Definging columns for INSERT statements - Mailing list pgsql-general

From	Rich Shepard
Subject	Definging columns for INSERT statements
Date	June 13 00:11:30
Msg-id	27d9076-c416-7847-7bd-159a5c3ee38a@appl-ecosys.com Whole thread Raw
Responses	Re: Defining columns for INSERT statements Re: Definging columns for INSERT statements Re: Definging columns for INSERT statements
List	pgsql-general

Tree view

I have > 100 rows to add to a table using INSERT INTO statements. I want the
PK to be the next value in the sequence. Would this be the appropriate
syntax for the columns to be entered?

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,activeDEFAULT('true')) VALUES
 
( ...

TIA,

Rich

pgsql-general by date:

From: Casey & Gina
Date: 12 June, 23:46:50
Subject: Re: Question about UNIX socket connections and SSL

From: Rich Shepard
Date: 13 June, 00:28:32
Subject: UPDATE with multiple WHERE conditions

Definging columns for INSERT statements - Mailing list pgsql-general

Previous

Next