Re: DDL - TYPES

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

 



On Fri, 2024-02-09 at 00:44 +0530, Gambhir Singh wrote:
> I was trying to generate DDL of functions and procedures and generated it successfully
> using the below query.
> 
> [...] SELECT pg_get_functiondef(f.oid) [...]
> 
> When I tried to execute the generated DDL on other DB, I am getting the below error.
> 
> 2024_02_07_IntegrationObjects_D0:3495: ERROR: type "xxxxxxxx" does not exist
> 
> 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'

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