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'