Re: Querying the field types of a table

Charles Tassell wrote:
> archives you will find more detail. Generally, the best way to find what
> you are looking for is to start psql with the -E option (echo queries sent

> At 03:30 PM 5/10/00, Dale Anderson wrote:
> >Is there a way to query the field names and types of a table in either 6.5
> >or 7.0?? I am writing an application, and in one piece, I need to get the
> >field names and field types of any table. Can this be done??? I have
> >searched both the web and documentation, and I can't seem to find a C
> >function or system table that has this information.

$tablename = table to query.

SELECT a.attname, t.typname
FROM pg_class c, pg_attribute a, pg_type t
WHERE c.relname = '$tablename'
and a.attnum >0 and a.attrelid = c.oid
and a.tttypid = t.oid
ORDER BY attname

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11