Skip site navigation (1) Skip section navigation (2)

Re: Finding column using SQL query.

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Schuhmacher, BretDate: 2005-02-09 11:03:54
Subject: Re: Duration betweeen 2 timestamps
Previous:From: Rajan BhideDate: 2005-02-09 09:56:20
Subject: Finding column using SQL query.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group