How to determine table definitions - Mailing list pgsql-novice

From Diane Moore
Subject How to determine table definitions
Date
Msg-id 3C757AC9.B9333FC3@drizzle.com
Whole thread Raw
List pgsql-novice
Hello -
I am brand new to PostgreSQL and am trying to list the field information
for a specific table in a database.  I would like to be able to query
the pg_attribute table, but can not determine the necessary "attrelid"
from the fields in the pg_class record for my table of interest.

Alternatively, is there a utility that just displays table-specific
information including fields, field lengths, datatypes, etc.?

Thanks much!
Diane


pgsql-novice by date:

Previous
From: Singer Wang
Date:
Subject: Re: Logging Apache web server log information to Postgresql
Next
From: "Keller, Sid"
Date:
Subject: Re: Logging Apache web server log information to Postgre