Re: DDL - TYPES
| От | Ron Johnson |
|---|---|
| Тема | Re: DDL - TYPES |
| Дата | |
| Msg-id | CANzqJaAWDb2EPrrWpuPW4afq2V8oJ6GgGUZVkCSA=WSem-APcQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: DDL - TYPES (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: DDL - TYPES
|
| Список | pgsql-admin |
On Thu, Feb 8, 2024 at 3:02 PM Laurenz Albe <laurenz.albe@cybertec.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?
В списке pgsql-admin по дате отправления: