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 vote178 views1 answer
Oracle temporary table
SQL
7 votes135 views2 answers
N highest salary in sql
SQL
1 vote123 views1 answer
Pl sql create table from another table
SQL
0 vote123 views2 answers
Mysql on update current_timestamp
SQL
19 votes125 views5 answers
Change column name mysql command line
SQL
1 vote120 views1 answer
Scaffold mysql database
SQL
12 votes131 views1 answer
Script to add new column in table sql
SQL
11 votes131 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote119 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote80 views1 answer
Kannst du deine finger trainieren
SQL