add column if doesn't exist - Mailing list pgsql-sql

From Brandon Metcalf
Subject add column if doesn't exist
Date
Msg-id Pine.LNX.4.58L.0509261534430.1453@cash.rhiamet.com
Whole thread Raw
Responses Re: add column if doesn't exist
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Chris Browne
Date:
Subject: Re: Possible to delete record from all tables at the same time?
Next
From: Michael Fuhr
Date:
Subject: Re: Updating cidr column with network operator