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

1 vote352 views1 answer
Install postgresql on raspberry pi
SQL
1 vote351 views1 answer
Increase existing date in sql oracle
SQL
0 vote370 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
10 votes354 views2 answers
Show tables in schema oracle
SQL
1 vote380 views1 answer
Oracle datafile max size 32gb
SQL
0 vote359 views1 answer
Check sql database table lock
SQL
4 votes344 views1 answer
Check database name postgresql
SQL
1 vote340 views1 answer
Oracle list constraints
SQL
2 votes401 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote397 views1 answer
Postgresql print sessions using the database
SQL