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

flow
  • 4,828
  • 6
  • 26
  • 41
  • Hmm but I have one problem : my table constraint_column_usage is empty.. – flow Feb 07 '14 at 13:19
  • Well, you should at least provide the exact version you're using then. – Jakub Kania Feb 07 '14 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`. – Craig Ringer Feb 07 '14 at 13:30

0 Answers0