From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thom Brown <thom@linux.com>
cc: Durumdara <durumdara@gmail.com>,
        Postgres General <pgsql-general@postgresql.org>
Subject: Re: Listing only the user defined types (with owners)
In-reply-to: <CAA-aLv4sNe7NX3scGhGUvqiwf3cp7wJrYD6GYs8qM=45Vmu9VA@mail.gmail.com>
References: <CAEcMXhki9OkNTSzyKZp9ehPOeCCc3J7hiacA_7=jQi4WYywBaQ@mail.gmail.com> <CAA-aLv4sNe7NX3scGhGUvqiwf3cp7wJrYD6GYs8qM=45Vmu9VA@mail.gmail.com>
Comments: In-reply-to Thom Brown <thom@linux.com>
	message dated "Thu, 02 May 2024 13:28:56 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2204950.1714659329.1@sss.pgh.pa.us>
Date: Thu, 02 May 2024 10:15:29 -0400
Message-ID: <2204951.1714659329@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/2204951.1714659329%40sss.pgh.pa.us>
Precedence: bulk

Thom Brown <thom@linux.com> writes:
> On Thu, 2 May 2024 at 12:40, Durumdara <durumdara@gmail.com> wrote:
>> Do you have a working Query which lists the user defined types with the
>> owners?

> You can always cheat and copy what psql does when you tell it to list all
> user types with extended output (\dt+):

If you want to look at what SQL psql issues for a \d-type command,
you don't even need to look at the server log.  Just start psql with
the -E (--echo-hidden) switch.

$ psql -E
psql (17devel)
Type "help" for help.

postgres=# \dT+
/******** QUERY *********/
SELECT n.nspname as "Schema",
  pg_catalog.format_type(t.oid, NULL) AS "Name",
  t.typname AS "Internal name",
  CASE WHEN t.typrelid != 0
      THEN CAST('tuple' AS pg_catalog.text)
    WHEN t.typlen < 0
      THEN CAST('var' AS pg_catalog.text)
    ELSE CAST(t.typlen AS pg_catalog.text)
  END AS "Size",
... etc etc ...

			regards, tom lane