From: | <email(at)juergen-cappel(dot)de> |
---|---|
To: | Rajan Bhide <rbhide(at)starentnetworks(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Finding column using SQL query. |
Date: | 2005-02-09 10:08:01 |
Message-ID: | 6312635$11079435144209e05a6981a0.44005217@config13.schlund.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Take a look at the system catalogs:
http://www.postgresql.org/docs/8.0/interactive/catalogs.html
HTH
Rajan Bhide <rbhide(at)starentnetworks(dot)com> schrieb am 09.02.2005,
10:56:20:
> Hi,
>
> Is there any way to find whether a particular column exists in the table
> or not based on the column name using sql query?
> I have a requirement where I need to find whether a column exists in the
> table or not using SQL query.
>
> Thanks,
> Rajan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
From | Date | Subject | |
---|---|---|---|
Next Message | Schuhmacher, Bret | 2005-02-09 11:03:54 | Re: Duration betweeen 2 timestamps |
Previous Message | Rajan Bhide | 2005-02-09 09:56:20 | Finding column using SQL query. |