#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    1
    Rep Power
    0

    Unhappy Show tables that are connected via foreign keys to particular table


    Hello,

    I would need help on how to:

    Show any tables that are connected to particular table via foreign keys.

    I need it when I access an unknown database and I know a particular table but there are other tables that are connected to it but I do not know which ones they are.

    Could you show me a hint how to do this with using information schema?

    Thank you,

    Jakub
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2009
    Posts
    7
    Rep Power
    0
    Go to the following link, Lorenzo has done GREAT work pulling information out the of the postgreSQL metadata schema:

    Lorenzo's PostgreSQL Information Schema Queries

    Thanks,

    Craig

IMN logo majestic logo threadwatch logo seochat tools logo