Re: column name with plpgsql

Thanks a lot Raymond it works well.

On Sat, Feb 7, 2009 at 3:32 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> 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
> ------------------------------------------------------------------
>

--
Alain
-----------------------------------------------------------
Windows XP x64 SP2 / Fedora 10 KDE 4.2
PostgreSQL 8.3.5 / MS SQL server 2005
Apache 2.2.10
PHP 5.2.6
C# 2005-2008