Listing only the user defined types (with owners)

[Durumdara <durumdara@xxxxxxxxx>]

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