Hello!
I have a script which can change the table owners to the database owner.
I select the tables like this:
FOR r IN SELECT tablename FROM pg_tables WHERE (schemaname = 'public')
and (tableowner <> act_dbowner)
LOOP
...
For types I found pg_type, but this contains all types.
For example I have only one user defined type, like "T_TEST", but this
pg_type relation contains the basic data types, other data types, from any
schema.
Do you have a working Query which lists the user defined types with the
owners?
Thank you for your help!
Best regards
dd