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
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster