X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D22E29FB37B for ; Thu, 3 Aug 2006 13:16:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 46031-05 for ; Thu, 3 Aug 2006 13:16:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 80FAD9FB375 for ; Thu, 3 Aug 2006 13:16:37 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 92FC530E11; Thu, 3 Aug 2006 18:16:36 +0200 (MET DST) From: "Andrew Hammond" X-Newsgroups: pgsql.sql Subject: Re: SELECT all fields except two Date: 3 Aug 2006 09:16:29 -0700 Organization: http://groups.google.com Lines: 24 Message-ID: <1154621789.772786.212160@75g2000cwc.googlegroups.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com In-Reply-To: User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.5) Gecko/20060731 Ubuntu/dapper-security Firefox/1.5.0.5,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: 75g2000cwc.googlegroups.com; posting-host=207.219.45.62; posting-account=cSUlcA0AAABWACaPjo2Z9C0GBLTio512 To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.095 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200608/26 X-Sequence-Number: 25984 This does not exist in SQL. However you could achieve similar functionality by doing a suitable query against the system info tables to find out what columns are available and then building your query appropriately. For an example, try psql -E -c '\d mytable' Drew Pit M. wrote: > select *,!Blob1,!Blob2 from MyTable > > Perhaps this is a construction that doesn't exist in the current SQL > standard at the moment. > Does anybody know the solution for that problem without explicitly > specifying the whole field list like: > > select Field1,Field2,...Field100 from MyTable > > > HP