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 vote361 views1 answer
Alter table add check constraint oracle
SQL
0 vote327 views2 answers
Sql if empty then
SQL
8 votes352 views1 answer
Today minus 15 days postgresql
SQL
4 votes299 views1 answer
Sql list users and roles
SQL
1 vote355 views1 answer
Sql select max value from multiple rows
SQL
16 votes346 views2 answers
Add column if not exists mysql
SQL
0 vote334 views1 answer
Check sql database table lock
SQL
0 vote334 views1 answer
MySQL get all previous date record
SQL
0 vote334 views2 answers
Getting customers with no orders sql
SQL
4 votes404 views2 answers
Delete all table oracle
SQL