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 vote314 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote163 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote180 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote167 views1 answer
Mysql changer nom table
SQL
0 vote171 views2 answers
Sql query print strings and int
SQL
0 vote178 views1 answer
Sqlcl format
SQL
0 vote165 views1 answer
Create view in sql server that contain multiple select statements
SQL
-1 vote152 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote162 views2 answers
Sql 2 way of select unique
SQL
0 vote153 views1 answer
SqlFunction does not exist
SQL