with recursive
  domains(domain_id, base_id, typbasetype, src) as (
    select
      d.oid,
      d.oid,
      d.typbasetype,
      case
        when c.oid is not null then array[pg_get_constraintdef(c.oid)]
      end
    from pg_catalog.pg_type as d
      join pg_catalog.pg_namespace as n
        on n.oid = d.typnamespace
      left outer join pg_catalog.pg_constraint as c
        on d.oid = c.contypid
    where (
      d.typtype = 'd'
      and n.nspname in ('testdrive')
    )
    union all
    select
      domains.domain_id,
      d.oid,
      d.typbasetype,
      case
        when c.conbin is null then domains.src
        else array_append(
          domains.src,
          pg_get_constraintdef(c.oid)
        )
      end
    from domains
      join pg_catalog.pg_type as d
        on domains.typbasetype = d.oid
      left outer join pg_catalog.pg_constraint as c
        on d.oid = c.contypid
  )
select
  n.nspname,
  d.typname,
  d.typnotnull,
  d.typdefault,
  b.typname,
  information_schema._pg_char_max_length(d.typbasetype, d.typtypmod) as character_maximum_length,
  information_schema._pg_numeric_precision(d.typbasetype, d.typtypmod) as numeric_precision,
  information_schema._pg_numeric_scale(d.typbasetype, d.typtypmod) as numeric_scale,
  domains.src
from pg_catalog.pg_type as d
  join domains
    on (
      domains.typbasetype = 0
      and domains.domain_id = d.oid
    )
  join pg_catalog.pg_type as b
    on domains.base_id = b.oid
  join pg_catalog.pg_namespace as n
    on n.oid = d.typnamespace
where (
  d.typtype = 'd'
  and n.nspname in ('testdrive')
)
order by n.nspname, d.typname

select 
  k.table_catalog, 
  k.table_schema, 
  k.table_name, 
  k.constraint_name, 
  k.column_name, 
  k.ordinal_position 
from 
  (
    pg_catalog.pg_constraint as c 
    join (
      pg_catalog.pg_class as alias_89552482 
      join pg_catalog.pg_namespace as alias_126892781 on alias_89552482.relnamespace = alias_126892781.oid
    ) on c.conrelid = alias_89552482.oid 
    join pg_catalog.pg_namespace as alias_87501535 on c.connamespace = alias_87501535.oid
  ) 
  join information_schema.key_column_usage as k on (
    k.table_schema = alias_126892781.nspname 
    and k.table_name = alias_89552482.relname 
    and k.constraint_schema = alias_87501535.nspname 
    and k.constraint_name = c.conname
  ) 
where 
  (
    c.contype = 'u' 
    and alias_87501535.nspname in (?)
  ) 
order by 
  k.table_schema asc, 
  k.table_name asc, 
  k.constraint_name asc, 
  k.ordinal_position asc;

cr> CREATE TABLE j1 (x INT);                                                    
cr> CREATE TABLE j2 (x INT);                                                    
cr> CREATE TABLE j3 (x INT);      
                                              
cr> SELECT * 
    FROM j1 
    JOIN (j2 JOIN j3 ON j2.x = j3.x) 
    ON j1.x = j2.x;                                                             
--IllegalStateException[joinPairs contains duplicate: Join{INNER doc.j2 ⇔ doc.j3} matches Join{INNER doc.j2 ⇔ doc.j3}]