List schema and tables from all databases in PostgreSQL cluster

list_postgresql_instance_tables.sh

psql -t --csv -d postgres -c "WITH get_database_names AS (
    SELECT d.datname as dbname
    FROM pg_catalog.pg_database d
    WHERE d.datname <> 'template0'
    ORDER BY 1
)
SELECT * FROM get_database_names;" >| databases.txt

echo "schemaname,tablename,dbname" >| all_tables.txt
for i in $(cat databases.txt);
    do psql -t --csv -d "${i}" -c "SELECT schemaname,tablename, '"${i}"' AS dbname
FROM pg_catalog.pg_tables
WHERE schemaname NOT IN ('pg_catalog','information_schema');" >> all_tables.txt;
done;