Как получить информацию о структуре БД для документации

SELECT 
  c.relname as "Таблица", 
  (
    SELECT 
      td.description 
    FROM 
      pg_catalog.pg_description td 
    WHERE 
      td.objoid = a.attrelid 
      AND td.objsubid = 0
  ) as "Комментарий к таблице", 
  a.attnum as "№ п/п", 
  a.attname as "Поле", 
  ad.description as "Комментарий к полю", 
  pt.typname as "Тип", 
  CASE WHEN a.atttypmod = -1 THEN NULL ELSE a.atttypmod END "Размер", 
  a.attnotnull as "NULL", 
  CASE WHEN a.attnum IN(
    SELECT 
      UNNEST(cn.conkey) 
    FROM 
      pg_catalog.pg_constraint cn 
    WHERE 
      cn.conrelid = a.attrelid 
      AND cn.contype LIKE 'p'
  ) THEN 'PK' END as "Ключ" 
FROM 
  pg_catalog.pg_attribute a 
  JOIN pg_catalog.pg_type pt ON a.atttypid = pt.oid 
  JOIN pg_catalog.pg_class c ON a.attrelid = c.oid 
  JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid 
  LEFT JOIN pg_catalog.pg_description ad ON ad.objoid = a.attrelid 
  AND ad.objsubid = a.attnum 
WHERE 
  a.attnum > 0 
  AND n.nspname = 'public' 
  and c.reltype <> 0
ORDER BY 
  c.relname, 
  a.attnum;

SELECT 
  cl.owner as "Владелец", 
  cl.table_name as "Таблица", 
  tc.comments as "Комментарий к таблице", 
  cl.internal_column_id as "№ п/п", 
  cl.column_name as "Поле", 
  cl.data_type as "Тип", 
  cl.data_length as "Размер", 
  cl.data_precision as "Точность", 
  cl.nullable as "NULL", 
  cm.comments as "Комментарий к полю" 
FROM 
  sys.all_tab_cols cl 
  JOIN sys.all_col_comments cm ON cl.owner = cm.owner 
  AND cl.table_name = cm.table_name 
  AND cl.column_name = cm.column_name 
  JOIN sys.all_tab_comments tc ON cl.owner = tc.owner 
  AND cl.table_name = tc.table_name 
WHERE 
  cl.owner = <имя схемы, если надо> 
ORDER BY 
  cl.table_name, 
  cl.internal_column_id;

SELECT 
  cl.table_name as "Таблица", 
  tc.comments as "Комментарий к таблице", 
  cl.internal_column_id as "№ п/п", 
  cl.column_name as "Поле", 
  cl.data_type as "Тип", 
  cl.data_length as "Размер", 
  cl.data_precision as "Точность", 
  cl.nullable as "NULL", 
  cm.comments as "Комментарий к полю" 
FROM 
  sys.user_tab_cols cl 
  JOIN sys.user_col_comments cm ON cl.table_name = cm.table_name 
  AND cl.column_name = cm.column_name 
  JOIN sys.user_tab_comments tc ON cl.table_name = tc.table_name 
ORDER BY 
  cl.table_name, 
  cl.internal_column_id

SELECT 
  * 
FROM 
  MSysObjects o 
WHERE 
  o.Flags = 0 
  AND o.Type = 1 
ORDER BY 
  o.NAME;

SELECT 
  * 
FROM 
  sqlite_master m 
WHERE 
  m.type = 'table';