select schema_name from information_schema.schemata;
SELECT
table_catalog
, table_schema
, table_name
, table_type
FROM
information_schema.tables
WHERE
table_schema = '[schema_name]';
=> \set SCHEMA_NAME 'bar'
=> CREATE SCHEMA :SCHEMA_NAME;
=> CREATE TABLE :SCHEMA_NAME.hoge (
uid character varying(80) NOT NULL,
data text,
PRIMARY KEY (uid)
);
=> \unset SCHEMA_NAME
select schemaname, relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze from pg_stat_all_tables;
relid | schemaname | relname | seq_scan | seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del | n_tup_hot_upd | n_live_tup | n_dead_tup | last_vacuum | last_autovacuum | last_analyze | last_autoanalyze | vacuum_count | autovacuum_count | analyze_count | autoanalyze_count
SELECT relname, reltuples, (relpages / 128) as mbytes, (relpages * 8192.0 / (reltuples + 1e-10)) as average_row_size FROM pg_class ORDER BY mbytes DESC;