save query as sql file

Started by Łukasz Jarychabout 8 years ago8 messagesgeneral
Jump to latest
#1Łukasz Jarych
jaryszek@gmail.com

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 ?

Best,
Jacek

#2Murtuza Zabuawala
murtuza.zabuawala@enterprisedb.com
In reply to: Łukasz Jarych (#1)
Re: save query as sql file

Refer screenshot attached.

​-- Murtuza​

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

Show quoted text

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 ?

Best,
Jacek

Attachments:

Save File.jpgimage/jpeg; name="Save File.jpg"Download+7-0
#3Murtuza Zabuawala
murtuza.zabuawala@enterprisedb.com
In reply to: Łukasz Jarych (#1)
Re: save query as sql file

++ Adding pgadmin-support

Please keep the group in the loop.

On Wed, Mar 7, 2018 at 4:19 PM, Murtuza Zabuawala <
murtuza.zabuawala@enterprisedb.com> wrote:

Show quoted text

No, You can provide any name in the file manager and it will save with
that name.
Check screenshot.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Hmm there is no otion to create new file - there is only option to save
as existing script yes ?

Jacek

2018-03-07 8:53 GMT+01:00 Łukasz Jarych <jaryszek@gmail.com>:

thank you !

Jacek

2018-03-07 8:24 GMT+01:00 Murtuza Zabuawala <
murtuza.zabuawala@enterprisedb.com>:

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:

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

where can i do it ?

Best,
Jacek

#4Łukasz Jarych
jaryszek@gmail.com
In reply to: Murtuza Zabuawala (#3)
Re: save query as sql file

thank you !!

2018-03-07 11:51 GMT+01:00 Murtuza Zabuawala <
murtuza.zabuawala@enterprisedb.com>:

Show quoted text

++ Adding pgadmin-support

Please keep the group in the loop.

On Wed, Mar 7, 2018 at 4:19 PM, Murtuza Zabuawala <murtuza.zabuawala@
enterprisedb.com> wrote:

No, You can provide any name in the file manager and it will save with
that name.
Check screenshot.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Hmm there is no otion to create new file - there is only option to save
as existing script yes ?

Jacek

2018-03-07 8:53 GMT+01:00 Łukasz Jarych <jaryszek@gmail.com>:

thank you !

Jacek

2018-03-07 8:24 GMT+01:00 Murtuza Zabuawala <
murtuza.zabuawala@enterprisedb.com>:

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:

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

where can i do it ?

Best,
Jacek

#5Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Łukasz Jarych (#1)
Re: save query as sql file

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

#6Łukasz Jarych
jaryszek@gmail.com
In reply to: Adrian Klaver (#5)
Re: save query as sql file

thank you !

Jacek

2018-03-07 14:45 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:

Show quoted text

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

#7Melvin Davidson
melvin6925@gmail.com
In reply to: Łukasz Jarych (#6)
Re: save query as sql file

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!

#8Łukasz Jarych
jaryszek@gmail.com
In reply to: Melvin Davidson (#7)
Re: save query as sql file

thanks you!

Jacek

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

Show quoted text

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!