More info on table fields

From: Alexander Cohen <alex(at)toomuchspace(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: More info on table fields
Date: 2004-03-02 13:18:01
Message-ID: 084189B1-6C4C-11D8-8CBE-000A95B947DC@toomuchspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Im looking to get a bit of info from a tables column. Im looking for if
the column is a primary key, im also looking for the columns
constraints and its foreign key reference if it is one. How can i get
theses with an SQL query?

--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Holmgren 2004-03-02 14:04:23 Data in table changed?
Previous Message Paul Thomas 2004-03-02 12:02:07 Re: Setting up Postgresql on Linux