Hi! Title says it pretty much. I am wondering if there is a short way to form a query that retrieves all fields of a table (of which I do not know names and number beforehand) except for one (or more, of which I know the name(s)). I have stumbled across the need for this a couple of time during the last few years. Maybe there is a way and I am just being blind ..
For instance, I would use this in a plpgsql function to select all fields but "bad_field" from a number of tables. I know the name of the field I DO NOT want, but number and names of the other fields (which I want) are not known at the time of writing the function. Thanx for your hints and please cc answers to my email. Regards Erwin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
