Re: [SQL] obtaining column names from tables or views

2007-11-28 Thread Richard Huxton
John van Zantvoort wrote: moin, I've got a question. I'm scripting against an existing postgresql database environment and need to tweak queries based on the columns in the views or tables, how can if find these w/o querying the tables or views. There is a whole section of the manual devoted t

[SQL] obtaining column names from tables or views

2007-11-28 Thread John van Zantvoort
moin, I've got a question. I'm scripting against an existing postgresql database environment and need to tweak queries based on the columns in the views or tables, how can if find these w/o querying the tables or views. Currently I execute the querie and collect the columns but this is rather exp