column names, types, properties for a table

From: Roger Tannous <roger77_lb(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: column names, types, properties for a table
Date: 2005-09-07 21:25:43
Message-ID: 20050907212543.88525.qmail@web51901.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Is it possible to issue an SQL query that lists column names, types (int,
varchar, boolean, etc.), properties (like NOT NULL or UNIQUE)
for a given table name ?

Regards,
Roger Tannous.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Matt Emmerton 2005-09-07 21:37:47 Re: Help with multistage query
Previous Message Tom Lane 2005-09-07 21:24:41 Re: uuid type for postgres