On Wed, Oct 11, 2006 at 12:26:19PM +0530, Indira Muthuswamy wrote: > Hai, > > Can anyone of you help me in finding the datatype of a particular > column in a table in Postgres?
Indira, You'll want to look at the columns view in the information_schema. http://www.postgresql.org/docs/current/static/information-schema.html Cheers, Dave. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
