pgdd

pig build pkg pgdd;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pgdd;		# install via package name, for the active PG version

pig install pgdd -v 18;   # install for PG 18
pig install pgdd -v 17;   # install for PG 17
pig install pgdd -v 16;   # install for PG 16
pig install pgdd -v 15;   # install for PG 15
pig install pgdd -v 14;   # install for PG 14

CREATE EXTENSION pgdd;

SELECT * FROM dd.database;

SELECT s_name, table_count, view_count, function_count, size_plus_indexes, description
  FROM dd.schemas;

SELECT t_name, size_pretty, rows, bytes_per_row
  FROM dd.tables
  WHERE s_name = 'public';

SELECT s_name, v_name, description FROM dd.views;

SELECT source_type, s_name, t_name, c_name, data_type
  FROM dd.columns
  WHERE data_type LIKE 'int%';

SELECT s_name, f_name, argument_data_types, result_data_types FROM dd.functions;

SELECT * FROM dd.partition_parents WHERE s_name = 'public';
SELECT * FROM dd.partition_children WHERE s_name = 'public';