Re: [SQL] add column if doesn't exist (fwd) - Mailing list pgsql-general

""Brandon Metcalf"" <bmetcalf@nortel.com> 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

Regards,
Qingqing