List all databases and tables
databases
SELECT datname FROM pg_database WHERE datistemplate = false;
tables
SELECT table_name FROM information_schema.tables where table_catalog='tablespace' and table_schema='public' and table_type='BASE TABLE' ORDER BY 1;
