This is a discussion on =?iso-8859-1?Q?Re:__Finding_column_using_SQL_query=2E?= within the pgsql Novice forums, part of the PostgreSQL category; --> Take a look at the system catalogs: http://www.postgresql.org/docs/8.0/i.../catalogs.html HTH Rajan Bhide <rbhide@starentnetworks.com> schrieb am 09.02.2005, 10:56:20: > Hi, > ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Take a look at the system catalogs: http://www.postgresql.org/docs/8.0/i.../catalogs.html HTH Rajan Bhide <rbhide@starentnetworks.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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org |