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.
