On Mon, Sep 26, 2005 at 07:16:53PM -0700, Qingqing Zhou wrote:
>
> ""Brandon Metcalf"" <[EMAIL PROTECTED]> 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_attr
""Brandon Metcalf"" <[EMAIL PROTECTED]> 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-attri
I figured pgsql-general would be a more appropriate forum for the
question below.
--
Brandon
-- Forwarded message --
Date: Mon, 26 Sep 2005 15:38:56 -0500 (CDT)
From: "Metcalf, Brandon [SC100:CM21:EXCH]" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: [SQL] add column i
