pgdd

pig build pkg pgdd         # 构建 RPM / DEB 包

pig repo add pgsql -u          # 添加仓库并更新缓存

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';