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 vote370 views1 answer
Print boolean in plsql
SQL
8 votes350 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote367 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote365 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
5 votes357 views1 answer
Postgres integer to serial
SQL
8 votes392 views1 answer
Oracle current date plus 1 month
SQL
6 votes352 views1 answer
Oracle list primary key
SQL
1 vote366 views1 answer
Oracle truncate partition
SQL
0 vote385 views1 answer
C# execute transact sql
SQL
0 vote391 views1 answer
Oracle insert single quote in string
SQL