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 vote200 views1 answer
Sqlite higher or equal
SQL
14 votes245 views3 answers
Inner join sql oracle
SQL
0 vote193 views1 answer
Add column to table with default value plsql
SQL
0 vote178 views1 answer
Mariadb set vertical output format
SQL
1 vote213 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote232 views1 answer
Postgres docs /copy metacomand
SQL
0 vote187 views1 answer
Get number of rows in every table mysql
SQL
0 vote210 views1 answer
Incorrect string value: mysql
SQL
18 votes190 views3 answers
Mysql current date
SQL
0 vote229 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL