Re: save SQL in PgAdmin4

On Thu, Jul 18, 2019 at 3:09 PM Ray O'Donnell <ray@rodonnell.ie> wrote:

On 18/07/2019 14:43, Michael Shapiro wrote:
> Then what?
>
> On Thu, Jul 18, 2019 at 8:31 AM Ray O'Donnell <ray@rodonnell.ie
> <mailto:ray@rodonnell.ie>> wrote:
>
>     On 18/07/2019 14:28, Michael Shapiro wrote:
>      > After selecting an object (eg a view) how do I save the SQL that
>      > PgAdmin4 extracts from the server? I don't see a "SAVE" button.
>      >
>
>     Hi there,
>
>     Right-click on it in the object tree (Left of screen), then select
>     Scripts -> (type of script required).

[Please keep replies on-list, and avoid top-posting - thanks.]

Now that you ask, that's a good question.... I just tried it myself
(Scripts -> Create script), and the "Save" button is greyed out.

You can activate it by making some small edit in the generated SQL, but
this seems like a bug.

Depends how you look at it. The button is looking for changes the user has made, not pre populated or loaded text. It's like when you double-click on a file and it opens in an editor - most will not enable the save button at that point.

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company