select schemaname, tablename
from pg_table_def -- system catalog table with table objects description (each row a column)
where schemaname not in ('admin', 'pg_catalog')
and ("column"='uniqueid' or "column"='unique_id')
order by 1, 2;


select xid, sequence, text
from stl_ddltext -- table keeping all DDL used to create database objects
where text like '% event_stream %'
order by sequence;

select xid, sequence, text
from stl_ddltext
where xid=74271988
order by sequence asc;