Re: Clarification needed

In psql, 
psql>\d tableName

Query is
SELECT pg_catalog.format_type(a.atttypid, a.atttypmod) from 
pg_attribute a, pg_class c where  a.attrelid =c.oid and 
c.relname='TableName' and a.attname='ColName';


Zdenek Kotala wrote:

>
> Look at http://www.postgresql.org/docs/8.1/interactive/catalogs.html
>
> Specially on pg_attribute, pg_class and pg_type table. Or you can use 
> some features in the psql.
>
>     Zdenek
>
>
> Indira Muthuswamy napsal(a):
>
>> Hai,
>>  
>> Can anyone of you help me in finding the datatype of a particular 
>> column in a table in Postgres?
>>  
>> Thanks and Regards,
>> M.Indira
>>  
>>  
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings