Postgres Pro
Downloads
Home   >   mailing lists

query to list all user tables and related constraints - Mailing list pgsql-admin

From Kevin Kempter
Subject query to list all user tables and related constraints
Date
Msg-id 201001212214.39213.kevink@consistentstate.com
Whole thread Raw
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: last insert/update for a table
Next
From: Shruthi A
Date:
Subject: Permission to postgres to another user's folder