Postgres check for foreign key

SELECT
    r.table_name
FROM information_schema.constraint_column_usage       u
INNER JOIN information_schema.referential_constraints fk
           ON u.constraint_catalog = fk.unique_constraint_catalog
               AND u.constraint_schema = fk.unique_constraint_schema
               AND u.constraint_name = fk.unique_constraint_name
INNER JOIN information_schema.key_column_usage        r
           ON r.constraint_catalog = fk.constraint_catalog
               AND r.constraint_schema = fk.constraint_schema
               AND r.constraint_name = fk.constraint_name
WHERE
    u.column_name = 'id' AND
    u.table_catalog = 'db_name' AND
    u.table_schema = 'public' AND
    u.table_name = 'table_a'

Source: stackoverflow.com

Similar codes

0 vote123 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
13 votes100 views6 answers
Mysql update from select
SQL
0 vote178 views1 answer
Sql to search who modified
SQL
3 votes110 views1 answer
Mysql load sql from file
SQL
0 vote75 views1 answer
Postgresql add leading zeros
SQL
1 vote113 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
1 vote113 views1 answer
Alter add syntax
SQL
0 vote114 views1 answer
How to save data in database in mysql node
SQL
4 votes104 views6 answers
Sql select statement
SQL
0 vote109 views1 answer
C# mysql update statement set value to null
SQL