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 <david@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!