you should use schemaname.tablename syntax if you are using schema
**
On 10/11/06, Dhanaraj M <Dhanaraj(dot)M(at)sun(dot)com> wrote:
>
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>