On 07/02/2009 14:26, Alain Roger wrote:
> i have a table which can be altered with several additional column. How can
> i test under plpgsql if a particular column already exists ?
select 1 from information_schema.columns
where table_name = 'your_table_name_here'
and column_name = 'your_column_name_here';
HTH,
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------