Обсуждение: Querying the field types of a table

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
inone piece, I need to get the field names and field types of any table.  Can this be done???  I have searched both the
weband documentation, and I can't seem to find a C function or system table that has this information. 

Thanks in advance,
Dale.

There has been discussion on this topic before, so if you check the
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
to the backend) and then issue a \dt or \d tablename command to see the
query it uses.

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.
>
>Thanks in advance,
>Dale.
>

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