[SQL] add column if doesn't exist (fwd)

["Brandon Metcalf" <bmetcalf@xxxxxxxxxx>]

I figured pgsql-general would be a more appropriate forum for the
question below.

-- 
Brandon

---------- Forwarded message ----------
Date: Mon, 26 Sep 2005 15:38:56 -0500 (CDT)
From: "Metcalf, Brandon [SC100:CM21:EXCH]" <bmetcalf@xxxxxxxxxxxxxxxxxx>
To: pgsql-sql@xxxxxxxxxxxxxx
Subject: [SQL] add column if doesn't exist

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?

I'm basically looking to do an ALTER TABLE foo ADD COLUMN bar if bar
doesn't exist.

Thanks.

-- 
Brandon

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match