Re: DDL - TYPES

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux