Re: Saving DDL to a file ...

Hi Arni,

On Fri, Oct 18, 2019 at 12:21 PM Arni Kromić <arni(dot)kromic(at)bios-ict(dot)hr>
wrote:

> On 18/10/2019 07.01, Avin Kavish wrote:
>
> Can't you copy and paste it?
>
> On Fri., 18 Oct. 2019, 9:27 am Khushboo Vashi, <
> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>> Hi Michael,
>>
>> On Thu, Oct 17, 2019 at 10:31 PM Michael Shapiro <mshapiro51(at)gmail(dot)com>
>> wrote:
>>
>>> When I look at the DDL for an object (eg view or function) under the SQL
>>> tab in PgAdmin4, how do I save it to a file?
>>>
>> Not supported right now but we do have a feature request for the same.
>> Ref: https://redmine.postgresql.org/issues/4493
>>
>>> Also, is there a way to run the DDL in a different database (so I can
>>> "copy" the object from one database to another)
>>>
>> No, I'm afraid.
>>
>> Thanks,
>> Khushboo
>>
>>
> Every object should also have "CREATE script" context menu item which
> opens in the Query Tool and can be saved from there...
>
It's already there.
[image: image.png]

>
> --
> Kind Regards,
> Arni Kromić
>
>

--
Thanks and Regards,
Aditya Toshniwal
Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"