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 vote133 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
4 votes173 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote126 views1 answer
Oracle tablespace autoextend
SQL
0 vote142 views1 answer
Left join vs inner join performance
SQL
2 votes128 views2 answers
How to create an empty table from an existing table
SQL
0 vote133 views1 answer
Create table if not exist with exceptions
SQL
0 vote175 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote91 views1 answer
Python escape string for sql
SQL
1 vote175 views1 answer
Postgresql blocked on mac
SQL
0 vote139 views1 answer
Mysql query to add hours to column in table
SQL