Original query:

$ \d distributions
                            Table "public.distributions"
   Column    │           Type           │ Collation │ Nullable │       Default       
─────────────┼──────────────────────────┼───────────┼──────────┼─────────────────────
 name        │ term                     │           │ not null │ 
 version     │ semver                   │           │ not null │ 
 abstract    │ text                     │           │ not null │ ''::text
 description │ text                     │           │ not null │ ''::text
 relstatus   │ relstatus                │           │ not null │ 'stable'::relstatus
 creator     │ label                    │           │ not null │ 
 sha1        │ citext                   │           │ not null │ 
 meta        │ text                     │           │ not null │ 
 created_at  │ timestamp with time zone │           │ not null │ now()
Indexes:
    "distributions_pkey" PRIMARY KEY, btree (name, version)
Foreign-key constraints:
    "distributions_creator_fkey" FOREIGN KEY (creator) REFERENCES users(nickname)
Referenced by:
    TABLE "distribution_extensions" CONSTRAINT "distribution_extensions_distribution_fkey" FOREIGN KEY (distribution, dist_version) REFERENCES distributions(name, version)


$ \d distribution_extensions
         Table "public.distribution_extensions"
    Column    │  Type  │ Collation │ Nullable │ Default 
──────────────┼────────┼───────────┼──────────┼─────────
 extension    │ term   │           │ not null │ 
 ext_version  │ semver │           │ not null │ 
 abstract     │ text   │           │ not null │ 
 distribution │ term   │           │ not null │ 
 dist_version │ semver │           │ not null │ 
Indexes:
    "distribution_extensions_pkey" PRIMARY KEY, btree (extension, ext_version, distribution, dist_version)
Foreign-key constraints:
    "distribution_extensions_distribution_fkey" FOREIGN KEY (distribution, dist_version) REFERENCES distributions(name, version)
    "distribution_extensions_extension_fkey" FOREIGN KEY (extension) REFERENCES extensions(name)


$ \dD+ term
                                                                               List of domains
 Schema │ Name │  Type  │ Collation │ Nullable │ Default │                                      Check                                      │ Access privileges │ Description 
────────┼──────┼────────┼───────────┼──────────┼─────────┼─────────────────────────────────────────────────────────────────────────────────┼───────────────────┼─────────────
 public │ term │ citext │           │          │         │ CHECK (VALUE !~ '[[:space:][:cntrl:]/\\]'::citext AND length(VALUE::text) >= 2) │ =U/pgxn_owner     │ 
(1 row)