On Thu, 2024-02-08 at 16:03 -0500, Ron Johnson wrote: > > I am trying to find a way to generate the DDL of the TYPE, but have not been successful. > > > > The canonical way is > > > > pg_dump --section=pre-data yourdbname | grep 'CREATE TYPE .*\.xxxxxxxx' > > They're never multi-line? Never, unless you create a type with a newline in its name: CREATE TYPE "my type" AS ENUM ('silly'); Yours, Laurenz Albe