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.
>
