query to list all user tables and related constraints

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: query to list all user tables and related constraints
Date: 2010-01-22 05:14:39
Message-ID: 201001212214.39213.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All;

anyone have a query that will list all user tables and their related
constraints

(i.e. for each table list any FK's for
and any tables/columns that reference the table)

Thanks in advance.

Browse pgsql-admin by date

  From Date Subject
Next Message Shruthi A 2010-01-22 08:57:41 Permission to postgres to another user's folder
Previous Message Kevin Grittner 2010-01-21 17:03:57 Re: last insert/update for a table