Received: from druid.net (root@druid.net [198.96.119.226]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA58684 for ; Tue, 25 May 1999 15:31:19 -0400 (EDT) (envelope-from darcy@druid.net) Received: from localhost (1291 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Tue, 25 May 1999 15:31:15 -0400 (EDT) (Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13) Message-Id: Subject: Re: [SQL] Stupid SQl question on inserting items In-Reply-To: <374ADE8E.E7895F5@ZotConsulting.com> from "Zot O'Connor" at "May 25, 1999 10:31:58 am" To: zot@ZotConsulting.com (Zot O'Connor) Date: Tue, 25 May 1999 15:31:15 -0400 (EDT) From: "D'Arcy" "J.M." Cain Cc: pgsql-sql@postgreSQL.org Reply-To: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL50 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Thus spake Zot O'Connor > 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. Specify the fields in the insert. INSERT INTO table_name (field1, field2, field4) VALUES (val1, val2, val4); This is a good idea in any case even when inserting to all fields in case something changes in the database schema. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.