MIME-Version: 1.0
From: Durumdara <durumdara@gmail.com>
Date: Thu, 2 May 2024 13:39:36 +0200
Message-ID: <CAEcMXhki9OkNTSzyKZp9ehPOeCCc3J7hiacA_7=jQi4WYywBaQ@mail.gmail.com>
Subject: Listing only the user defined types (with owners)
To: Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006a352e0617770fb9"
Archived-At: <https://www.postgresql.org/message-id/CAEcMXhki9OkNTSzyKZp9ehPOeCCc3J7hiacA_7%3DjQi4WYywBaQ%40mail.gmail.com>
Precedence: bulk

--0000000000006a352e0617770fb9
Content-Type: text/plain; charset="UTF-8"

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

--0000000000006a352e0617770fb9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello!<div><br></div><div>I have a script which can change=
 the table owners to the database owner.</div><div><br></div><div>I select =
the tables like this:</div><div><br></div><div><font face=3D"monospace">=C2=
=A0 =C2=A0 FOR r IN SELECT tablename FROM pg_tables WHERE (schemaname =3D &=
#39;public&#39;) and (tableowner &lt;&gt; act_dbowner)<br>=C2=A0 =C2=A0 LOO=
P<br></font></div><div>...</div><div><br></div><div>For types I found pg_ty=
pe, but this contains all types.</div><div><br></div><div>For example I hav=
e only one user defined type, like &quot;T_TEST&quot;, but this pg_type rel=
ation contains the basic data types,=C2=A0 other data types, from any schem=
a.</div><div><br></div><div>Do you have a working Query which lists the use=
r defined types with the owners?</div><div><br></div><div>Thank you for=C2=
=A0your help!</div><div><br></div><div>Best regards</div><div>dd</div><div>=
<br></div><div><br></div></div>

--0000000000006a352e0617770fb9--