| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: DDL - TYPES |
| Date: | 2024-02-08 21:03:38 |
| Message-ID: | CANzqJaAWDb2EPrrWpuPW4afq2V8oJ6GgGUZVkCSA=WSem-APcQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Feb 8, 2024 at 3:02 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> 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'
>
They're *never* multi-line?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2024-02-08 21:41:19 | Re: pg_basebackup --wal-method=fetch |
| Previous Message | Laurenz Albe | 2024-02-08 20:02:26 | Re: DDL - TYPES |