Search Postgresql Archives

Re: Select all fields except one

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



There’s probably some way to pull all the field names from the metadata tables and build a query on-the-fly that selects all but the offensive one.

 


From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Matt Doughty
Sent: Wednesday, November 28, 2007 11:07 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Select all fields except one

 

Hi,

Is there a way of selecting all fields except for one in particular? I'd like to create a query that says something like:

 

select * except fieldx

 

What I’m hoping to achieve is a query that can be valid for a number of different tables, although the field I don’t want to select is always called the same (field_not_wanted, for example). I’ve been told that an array could work in this case but I’m not reallly sure about how to go about this.  

 
Cheers,

Matt

 

 

 

 

Matt Doughty

GEOGRAMA S.L.

Tel.:  +34 945 13 13 72    652 77 14 15

Fax: +34 945 23 03 40

www.geograma.com

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux