| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Andreas Joseph Krogh <andreas(at)visena(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: List all columns referencing an FK |
| Date: | 2018-04-09 17:45:08 |
| Message-ID: | ce8f656d-b6d3-5481-8a98-6c92e92afdbd@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2018-04-09 18:09:06 | Re: How to monitor logical replication initial sync? |
| Previous Message | Steve Atkins | 2018-04-09 16:01:08 | Re: best way to write large data-streams quickly? |