Thread: save query as sql file

save query as sql file

From
Łukasz Jarych
Date:
Hello,

I ma trying to save query as sql file in pg_admin4 but file --> save as not exists like here:


where can i do it ?

Best,
Jacek 

Re: save query as sql file

From
Murtuza Zabuawala
Date:
Refer screenshot attached.

​-- Murtuza​


On Wed, Mar 7, 2018 at 12:37 PM, Łukasz Jarych <jaryszek@gmail.com> wrote:
Hello,

I ma trying to save query as sql file in pg_admin4 but file --> save as not exists like here:


where can i do it ?

Best,
Jacek 

Attachment

Re: save query as sql file

From
Adrian Klaver
Date:
On 03/06/2018 11:07 PM, Łukasz Jarych wrote:
> Hello,
> 
> I ma trying to save query as sql file in pg_admin4 but file --> save as 
> not exists like here:
> 
> https://www.youtube.com/watch?v=L4KJ_Kpymh4
> 
> where can i do it ?
> 

Well according to manual:

https://www.pgadmin.org/docs/pgadmin4/2.x/query_tool.html

Query tool toolbar


Click the Save icon to perform a quick-save of a previously saved query, 
or to access the Save menu:

         Select Save to save the selected content of the SQL Editor 
panel in a file.
         Select Save As to open a new browser dialog and specify a new 
location to which to save the selected content of the SQL Editor panel.



> Best,
> Jacek


-- 
Adrian Klaver
adrian.klaver@aklaver.com


Re: save query as sql file

From
Łukasz Jarych
Date:
thank you ! 

Jacek 

2018-03-07 14:45 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 03/06/2018 11:07 PM, Łukasz Jarych wrote:
Hello,

I ma trying to save query as sql file in pg_admin4 but file --> save as not exists like here:

https://www.youtube.com/watch?v=L4KJ_Kpymh4

where can i do it ?


Well according to manual:

https://www.pgadmin.org/docs/pgadmin4/2.x/query_tool.html

Query tool toolbar


Click the Save icon to perform a quick-save of a previously saved query, or to access the Save menu:

        Select Save to save the selected content of the SQL Editor panel in a file.
        Select Save As to open a new browser dialog and specify a new location to which to save the selected content of the SQL Editor panel.



Best,
Jacek


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: save query as sql file

From
Melvin Davidson
Date:


On Wed, Mar 7, 2018 at 8:46 AM, Łukasz Jarych <jaryszek@gmail.com> wrote:
thank you ! 

Jacek 

2018-03-07 14:45 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 03/06/2018 11:07 PM, Łukasz Jarych wrote:
Hello,

I ma trying to save query as sql file in pg_admin4 but file --> save as not exists like here:

https://www.youtube.com/watch?v=L4KJ_Kpymh4

where can i do it ?


Well according to manual:

https://www.pgadmin.org/docs/pgadmin4/2.x/query_tool.html

Query tool toolbar


Click the Save icon to perform a quick-save of a previously saved query, or to access the Save menu:

        Select Save to save the selected content of the SQL Editor panel in a file.
        Select Save As to open a new browser dialog and specify a new location to which to save the selected content of the SQL Editor panel.



Best,
Jacek


--
Adrian Klaver
adrian.klaver@aklaver.com



> trying to save query as sql file in pg_admin4 but file --> save as not exists like here:

As previously answered, you have to use the icon(s) for all options in the query window

FYI,In October 2017, I entered Feature request #2797 in PgAdmin's redmin to add a MENU to the query window in addition to the icons.
That request is still open.

https://redmine.postgresql.org/issues/2797

--
Melvin Davidson
Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!

Re: save query as sql file

From
Łukasz Jarych
Date:
thanks you!

Jacek

2018-03-07 15:00 GMT+01:00 Melvin Davidson <melvin6925@gmail.com>:


On Wed, Mar 7, 2018 at 8:46 AM, Łukasz Jarych <jaryszek@gmail.com> wrote:
thank you ! 

Jacek 

2018-03-07 14:45 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 03/06/2018 11:07 PM, Łukasz Jarych wrote:
Hello,

I ma trying to save query as sql file in pg_admin4 but file --> save as not exists like here:

https://www.youtube.com/watch?v=L4KJ_Kpymh4

where can i do it ?


Well according to manual:

https://www.pgadmin.org/docs/pgadmin4/2.x/query_tool.html

Query tool toolbar


Click the Save icon to perform a quick-save of a previously saved query, or to access the Save menu:

        Select Save to save the selected content of the SQL Editor panel in a file.
        Select Save As to open a new browser dialog and specify a new location to which to save the selected content of the SQL Editor panel.



Best,
Jacek


--
Adrian Klaver
adrian.klaver@aklaver.com



> trying to save query as sql file in pg_admin4 but file --> save as not exists like here:

As previously answered, you have to use the icon(s) for all options in the query window

FYI,In October 2017, I entered Feature request #2797 in PgAdmin's redmin to add a MENU to the query window in addition to the icons.
That request is still open.

https://redmine.postgresql.org/issues/2797

--
Melvin Davidson
Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!