Home Postgres: SQL to list table foreign keys
Reply: 0

Postgres: SQL to list table foreign keys

user4417
1#
user4417 Published in September 19, 2018, 11:10 am

Is there a way using SQL to list all foreign keys for a given table? I know the table name / schema and I can plug that in.

share|improve this question
  • I suggest to use @Magnus' answer. Simplest, cleanest, fastest. – Erwin Brandstetter Oct 10 '13 at 15:04

20 Answers 20

active oldest votes
up vote 258 down vote accepted
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.56522 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO