On 3/8/23 15:29, Bryn Llewellyn wrote: [snip]
create table s.t(k int primary key, c1 int, c2 int, c3 int); insert into s.t(k, c1, c2, c3) values(1, 17, 42, 57); create type s.x as (c1 int, c2 int, c3 int);
[snip] This is an excellent analysis.
Native PG doesn't provide much metadata or tooling to help you here. You need your own reliable humanly written external doc of your system.
"pg_dump --schema-only" and then grep for type x? -- Born in Arizona, moved to Babylonia.
