Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 74A674769E7 for ; Tue, 11 Jun 2002 14:48:37 -0400 (EDT) Received: from relay2.uswest.net (relay4.uswest.net [63.226.138.12]) by postgresql.org (Postfix) with SMTP id 8E4B64764FF for ; Tue, 11 Jun 2002 14:21:05 -0400 (EDT) Received: (qmail 55157 invoked by uid 0); 11 Jun 2002 18:21:05 -0000 Received: from unknown (HELO ?192.168.5.207?) (209.180.142.225) by relay2.uswest.net with SMTP; 11 Jun 2002 18:21:05 -0000 Subject: Select * (but exclude columns) From: Adam To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.3 (1.0.3-6) Date: 11 Jun 2002 11:21:05 -0700 Message-Id: <1023819665.1834.14.camel@localhost.localdomain> Mime-Version: 1.0 X-Archive-Number: 200206/144 X-Sequence-Number: 8109 does anybody know the syntax to select all columns from a table expect one (or more)? Can it be done? I'm almost positive I've seen it done before. Maybe I was dreaming cause I can't find any documention on it.