Re: save SQL in PgAdmin4

On Thu, Jul 18, 2019 at 3:09 PM Ray O'Donnell <ray(at)rodonnell(dot)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(at)rodonnell(dot)ie
> > <mailto:ray(at)rodonnell(dot)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