0

I want to retrieve these informations from PostgreSQL for one table name :

For each foreign key, the name of the field corresponding to the fk, and the name of the table witch is referenced by.

Can I do it with sql query ?
Thanks for help

Improve this question
3
  • Hmm but I have one problem : my table constraint_column_usage is empty.. Commented Feb 7, 2014 at 13:19
  • Well, you should at least provide the exact version you're using then. Commented Feb 7, 2014 at 13:28
  • 1
    If the usual solution doesn't work, please provide more detail. SELECT version(), the SQL used to create the table(s), and the SQL used to query the information_schema. Commented Feb 7, 2014 at 13:30
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.