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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
