Received: from eater.zotnet.com (IDENT:root@snapuser87.pacificcrest.net [216.36.24.87]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA35851 for ; Tue, 25 May 1999 13:10:43 -0400 (EDT) (envelope-from zot@ZotConsulting.com) Received: from ZotConsulting.com (snapuser115.pacificcrest.net [216.36.24.115]) by eater.zotnet.com (8.8.7/8.8.7) with ESMTP id KAA21600 for ; Tue, 25 May 1999 10:13:15 -0700 Message-ID: <374ADE8E.E7895F5@ZotConsulting.com> Date: Tue, 25 May 1999 10:31:58 -0700 From: "Zot O'Connor" Organization: Zot Consulting X-Mailer: Mozilla 4.5 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Stupid SQl question on inserting items Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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...) or the COPY method? It is becoming a chore to sync up a table with a lot of fields. I am porting several DB into postgres and using a variety of techniques to do it (some of these are poorly formatted text files). Most of the fields are blank, so when I goof up, I spend 15 minutes comparing files to find the problem. The elusive "parse error near '" does not help much :) I thought I knew how to do this with Postgres but can't seem to find it in my notes. I thought something along the lines of insert a blank (except for id) record than updating it with name pairs might work. -- Zot O'Connor www.ZotConsulting.com www.WhiteKnightHackers.com