Find all the tables that reference a given table

foreign_key_references.sh

#!/bin/bash

table_to_check_references_to='table_name'
database_name='dbname'

query=$(cat <<SQL
SELECT
    table_constraints.table_schema,
    table_constraints.constraint_name,
    table_constraints.table_name,
    key_column_usage.column_name,
    constraint_column_usage.table_schema AS foreign_table_schema,
    constraint_column_usage.table_name AS foreign_table_name,
    constraint_column_usage.column_name AS foreign_column_name
FROM
    information_schema.table_constraints AS table_constraints
    JOIN information_schema.key_column_usage AS key_column_usage
      ON table_constraints.constraint_name = key_column_usage.constraint_name
      AND table_constraints.table_schema = key_column_usage.table_schema
    JOIN information_schema.constraint_column_usage AS constraint_column_usage
      ON constraint_column_usage.constraint_name = table_constraints.constraint_name
      AND constraint_column_usage.table_schema = table_constraints.table_schema
WHERE table_constraints.constraint_type = 'FOREIGN KEY'
  AND table_constraints.table_name='$table_to_check_references_to';
SQL)

psql --dbname $database_name --echo-all --command "$query"