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