Re: [SQL] Stupid SQl question on inserting items - Mailing list pgsql-sql

From Gregory W Burnham
Subject Re: [SQL] Stupid SQl question on inserting items
Date
Msg-id 010101bea6d3$fec842c0$3d063a8e@educ.sfu.ca
Whole thread Raw
In response to Stupid SQl question on inserting items  ("Zot O'Connor" <zot@ZotConsulting.com>)
List pgsql-sql
> This is a dumb basic level SQL question.
>
> is there any other way to insert records without having to fill in all
> of the values as in
>
> INSERT into table_name WITH VALUES (blah, blah, blah...)

Yes, you can INSERT into table_name (field_one, field_two, field_five)
VALUES
(value_one, value_two, value_five);

Gregory W Burnham
Software Engineer /
Systems Administrator
Excite Labs
Simon Fraser University
Vancouver, BC
V5A 1S6
604 291 3615 ph
604 291 5679 fx



pgsql-sql by date:

Previous
From: "Zot O'Connor"
Date:
Subject: Stupid SQl question on inserting items
Next
From: Oleg Bartunov
Date:
Subject: Re: [SQL] Stupid SQl question on inserting items