From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | Durumdara <durumdara(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Listing only the user defined types (with owners) |
Date: | 2024-05-02 14:15:29 |
Message-ID: | 2204951.1714659329@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thom Brown <thom(at)linux(dot)com> writes:
> On Thu, 2 May 2024 at 12:40, Durumdara <durumdara(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-05-02 14:43:21 | Re: How to interpret 'depends on' errors in pg_restore? |
Previous Message | Ron Johnson | 2024-05-02 12:32:34 | Re: Prevent users from executing pg_dump against tables |