Thread: Saving DDL to a file ...

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?

Also, is there a way to run the DDL in a different database (so I can "copy" the object from one database to another)

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.vashi@enterprisedb.com> wrote:

Hi Michael,

On Thu, Oct 17, 2019 at 10:31 PM Michael Shapiro <mshapiro51@gmail.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ć