Re: Saving DDL to a file ...

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
> <mailto: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 <mailto: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...

--
Kind Regards,
Arni Kromić