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