Postgres Pro
Downloads
Home   >   mailing lists

Thread: save location for queries

save location for queries

From
Joseph Montibello
Date:
Hi,

Is there a way to set a default path where my .sql query files should be saved and opened from? I keep all of them in a
specificfolder outside of the “Documents” folder and I’d like to be able to set it as a default.
 

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within the package itself using Finder, but
didn’tsee anything that looked relevant. I also looked through the online documentation and did a few searches in the
listarchives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, running on a Mac with OS X 10.10.4.
 

Thanks for any suggestions you can provide. Take care,
Joe Montibello

Re: save location for queries

From
Melvin Davidson
Date:
<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace,
sans-serif;font-size:24px"><divid="yui_3_16_0_1_1437582891793_2909">Options</div><div
id="yui_3_16_0_1_1437582891793_2885"> Query Tool</div><div dir="ltr" id="yui_3_16_0_1_1437582891793_2908">   
Favourites Favourites file path ?<br /></div><div id="yui_3_16_0_1_1437582891793_2884"><span></span></div><div
id="yui_3_16_0_1_1437582891793_2883"> </div><divclass="signature" id="yui_3_16_0_1_1437582891793_2795"><div
id="RTEContent"><fontid="yui_3_16_0_1_1437582891793_2882" size="4"><span id="yui_3_16_0_1_1437582891793_2881"
style="font-weight:bold;font-family:arial;color:rgb(0,0, 255);">Melvin Davidson </span></font><br /><font
id="yui_3_16_0_1_1437582891793_2863"size="3">     Cell 720-320-0155 <br /></font><br /><font
id="yui_3_16_0_1_1437582891793_2811"size="3" style="font-weight:bold;"><span id="yui_3_16_0_1_1437582891793_2812"
style="color:rgb(128,0, 255);">I reserve the right to fantasize.  Whether or not you </span><br style="color:rgb(128,
0,255);" /><span id="yui_3_16_0_1_1437582891793_2810" style="color:rgb(128, 0, 255);">wish to share my fantasy is
entirelyup to you. </span><img class="" data-id="15a12903-7049-51e9-ad6c-ed3acbdaac81"
id="yui_3_16_0_1_1437582891793_2960"src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"
style="color:rgb(128,0, 255);" /><br /><br />www.youtube.com/unusedhero<br style="color:rgb(128, 0, 255);" /></font><br
/><fontid="yui_3_16_0_1_1437582891793_2865" size="3"><span id="yui_3_16_0_1_1437582891793_2864"
style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span
id="yui_3_16_0_1_1437582891793_2866"style="font-weight:bold;font-family:courier;"><br />www.folkalley.com<br /><br
/></span></font></div></div><br/><div id="yui_3_16_0_1_1437582891793_2869" style="font-family: Courier New, courier,
monaco,monospace, sans-serif; font-size: 24px;"><div id="yui_3_16_0_1_1437582891793_2868" style="font-family:
HelveticaNeue,Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"><div dir="ltr"
id="yui_3_16_0_1_1437582891793_2867"><hrid="yui_3_16_0_1_1437582891793_2990" size="1" /><font face="Arial"
id="yui_3_16_0_1_1437582891793_2872"size="2"> <b id="yui_3_16_0_1_1437582891793_2871"><span
id="yui_3_16_0_1_1437582891793_2870"style="font-weight:bold;">From:</span></b> Joseph Montibello
<Joseph.Montibello@dartmouth.edu><br/><b><span style="font-weight: bold;">To:</span></b>
"pgadmin-support@postgresql.org"<pgadmin-support@postgresql.org> <br /><b
id="yui_3_16_0_1_1437582891793_2919"><spanid="yui_3_16_0_1_1437582891793_2918" style="font-weight:
bold;">Sent:</span></b>Wednesday, July 22, 2015 11:40 AM<br /><b id="yui_3_16_0_1_1437582891793_2921"><span
id="yui_3_16_0_1_1437582891793_2920"style="font-weight: bold;">Subject:</span></b> [pgadmin-support] save location for
queries<br/></font></div><div class="y_msg_container" id="yui_3_16_0_1_1437582891793_2880"><br />Hi,<br /><br />Is
therea way to set a default path where my .sql query files should be saved and opened from? I keep all of them in a
specificfolder outside of the “Documents” folder and I’d like to be able to set it as a default.<br /><br />I tried
lookingin PGAdmin3 > Preferences. I looked through Info.plist within the package itself using Finder, but didn’t see
anythingthat looked relevant. I also looked through the online documentation and did a few searches in the list
archivesbut I couldn’t find this. I’m using pgAdminIII version 1.20.0, running on a Mac with OS X 10.10.4.<br /><br
/>Thanksfor any suggestions you can provide. Take care,<br />Joe Montibello<br /><br />-- <br />Sent via
pgadmin-supportmailing list (<a href="mailto:pgadmin-support@postgresql.org"
ymailto="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/>To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/><br /><br /></div></div></div></div>

Re: save location for queries

From
Joseph Montibello
Date:
Hi,

Thanks for the reply! I think I’m missing something, though. In looking at the “favourites file path” in the documentation, it looks like it’s a place to store bits and pieces of SQL queries that you might want to re-use when constructing other queries. When I’m working in the query builder and hit the folder icon to open a saved query, it always opens up my “Documents” folder, which is the behavior I’d like to change.

I did try changing “Options > Query Tool > Favourites > Favourites file path” to be the path to the directory where I’m putting all my .sql files (saved queries). But when I do that, it just says it couldn’t open the path.

Joe Montibello


On Jul 22, 2015, at 12:39 PM, Melvin Davidson <melvin6925@yahoo.com> wrote:

Options
  Query Tool
    Favourites  Favourites file path ?
 
Melvin Davidson
    Cell 720-320-0155

I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

www.youtube.com/unusedhero

Folk Alley - All Folk - 24 Hours a day
www.folkalley.com


From: Joseph Montibello <Joseph.Montibello@dartmouth.edu>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Wednesday, July 22, 2015 11:40 AM
Subject: [pgadmin-support] save location for queries

Hi,

Is there a way to set a default path where my .sql query files should be saved and opened from? I keep all of them in a specific folder outside of the “Documents” folder and I’d like to be able to set it as a default.

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within the package itself using Finder, but didn’t see anything that looked relevant. I also looked through the online documentation and did a few searches in the list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, running on a Mac with OS X 10.10.4.

Thanks for any suggestions you can provide. Take care,
Joe Montibello

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support



Re: save location for queries

From
Guillaume Lelarge
Date:
Hi,

2015-07-22 20:52 GMT+02:00 Joseph Montibello <Joseph.Montibello@dartmouth.edu>:
Hi,

Thanks for the reply! I think I’m missing something, though. In looking at the “favourites file path” in the documentation, it looks like it’s a place to store bits and pieces of SQL queries that you might want to re-use when constructing other queries. When I’m working in the query builder and hit the folder icon to open a saved query, it always opens up my “Documents” folder, which is the behavior I’d like to change.

I did try changing “Options > Query Tool > Favourites > Favourites file path” to be the path to the directory where I’m putting all my .sql files (saved queries). But when I do that, it just says it couldn’t open the path.


Because it's waiting for a file to put favourites queries in it. That's not what you're looking for. And as far as I know, what you're looking for doesn't exist in pgAdmin.
 
Joe Montibello


On Jul 22, 2015, at 12:39 PM, Melvin Davidson <melvin6925@yahoo.com> wrote:

Options
  Query Tool
    Favourites  Favourites file path ?
 
Melvin Davidson
    Cell 720-320-0155

I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

www.youtube.com/unusedhero

Folk Alley - All Folk - 24 Hours a day
www.folkalley.com


From: Joseph Montibello <Joseph.Montibello@dartmouth.edu>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Wednesday, July 22, 2015 11:40 AM
Subject: [pgadmin-support] save location for queries

Hi,

Is there a way to set a default path where my .sql query files should be saved and opened from? I keep all of them in a specific folder outside of the “Documents” folder and I’d like to be able to set it as a default.

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within the package itself using Finder, but didn’t see anything that looked relevant. I also looked through the online documentation and did a few searches in the list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, running on a Mac with OS X 10.10.4.

Thanks for any suggestions you can provide. Take care,
Joe Montibello

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support






--

Re: save location for queries

From
Joseph Montibello
Date:
Thanks for clearing that up. 

Joe Montibello



On Jul 22, 2015, at 3:36 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:

Hi,

2015-07-22 20:52 GMT+02:00 Joseph Montibello <Joseph.Montibello@dartmouth.edu>:
Hi,

Thanks for the reply! I think I’m missing something, though. In looking at the “favourites file path” in the documentation, it looks like it’s a place to store bits and pieces of SQL queries that you might want to re-use when constructing other queries. When I’m working in the query builder and hit the folder icon to open a saved query, it always opens up my “Documents” folder, which is the behavior I’d like to change.

I did try changing “Options > Query Tool > Favourites > Favourites file path” to be the path to the directory where I’m putting all my .sql files (saved queries). But when I do that, it just says it couldn’t open the path.


Because it's waiting for a file to put favourites queries in it. That's not what you're looking for. And as far as I know, what you're looking for doesn't exist in pgAdmin.
 
Joe Montibello


On Jul 22, 2015, at 12:39 PM, Melvin Davidson <melvin6925@yahoo.com> wrote:

Options
  Query Tool
    Favourites  Favourites file path ?
 
Melvin Davidson
    Cell 720-320-0155

I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

www.youtube.com/unusedhero

Folk Alley - All Folk - 24 Hours a day
www.folkalley.com


From: Joseph Montibello <Joseph.Montibello@dartmouth.edu>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Wednesday, July 22, 2015 11:40 AM
Subject: [pgadmin-support] save location for queries

Hi,

Is there a way to set a default path where my .sql query files should be saved and opened from? I keep all of them in a specific folder outside of the “Documents” folder and I’d like to be able to set it as a default.

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within the package itself using Finder, but didn’t see anything that looked relevant. I also looked through the online documentation and did a few searches in the list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, running on a Mac with OS X 10.10.4.

Thanks for any suggestions you can provide. Take care,
Joe Montibello

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support






--