On Mon, Sep 26, 2005 at 07:16:53PM -0700, Qingqing Zhou wrote: > > ""Brandon Metcalf"" <bmetcalf@xxxxxxxxxx> wrote > > > > Is there a way to check for the existence of a column in a table other > > than, say, doing a SELECT on that column name and checking the output? > > > > Take a look at pg_attribute system table. > http://www.postgresql.org/docs/8.0/static/catalog-pg-attribute.html You might find the information_schema or pg_newsysviews (http://pgfoundry.org/projects/newsysviews/) easier to use. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
