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.