Re: [HACKERS] Clarification needed - Mailing list pgsql-general

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

Remember to vote!