Re: List all columns referencing an FK - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: List all columns referencing an FK
Date
Msg-id ce8f656d-b6d3-5481-8a98-6c92e92afdbd@2ndquadrant.com
Whole thread Raw
In response to List all columns referencing an FK  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
On 2/8/18 05:31, Andreas Joseph Krogh wrote:
> Back in 2008 I asked this
>
question: http://www.postgresql-archive.org/Finding-all-tables-that-have-foreign-keys-referencing-a-table-td2153236.html

> I wonder, is this now possible using information_schema only, or are
> there still pieces missing in the standard holding this back?

I think you'll still have the same problems if the same constraint name
appears more than once per schema.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: best way to write large data-streams quickly?
Next
From: Peter Eisentraut
Date:
Subject: Re: How to monitor logical replication initial sync?