Feb 23 2007
PostgreSQL: Determine if a column exists or not.
Here’s a quick query you can run to determine whether or not a particular column in a table exists or not:
Of course, replace YOURTABLENAME and YOURCOLUMNNAME with the proper values. If a row is returned, a column with that name exists, otherwise it does not.

