Forum OpenACS Q&A: View Postgres table constraints

Collapse
1: View Postgres table constraints
Posted by Clara schroeder on 10/08/04 07:55 PM
Where are the table constraints located? I'm trying to view Primary keys, column types, column names etc from a postgres table. Can anyone tell me how I can get column names, column types, column length, null or not.. etc..
Collapse
2: Re: View Postgres table constraints (response to 1)
Posted by Claudio Pasolini on 10/09/04 03:37 PM
Try \d tablename in psql or simply install and use the schema-browser package.