Re: Is there a way to export favourites from pgadmin3 on Lates macOS version(Catalina)
Jack Royal-Gordon <[email protected]> Fri, 15 Nov 2019 08:40:49 -0800
| Newsgroups | gmane.comp.db.postgresql.pgadmin |
|---|---|
| Message-ID | <[email protected]> |
--Apple-Mail=_B4B2270B-AF4A-462C-9D3A-9CACA052B9A3 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I just looked at my pgAdmin III configuration files (in ~) and there is = an XML file =E2=80=9C.pgadminfavourites=E2=80=9D that seems to contain = favorite queries.=20 <?xml version=3D"1.0" encoding=3D"UTF-8"?> <favourites> <favourite title=3D"Test">select date, sum(sold-returned) from = barnes_and_noble_sales_points where date >=3D '11/1/19' and book_id in (select id from books where user_id =3D 867) group by 1 = order by 1 select max(starting_date) from apple_trend_points where book_id in = (select id from books where user_id =3D 3893) select starting_date, sum(qty) from apple_trend_points where = starting_date >=3D '11/1/19' and book_id in (select id from books where user_id =3D 1) group by 1 = order by 1 select date, sum(paid_sales + free_sales) from sales_points where date = >=3D '11/1/19' and distributor_id =3D 3 and book_id in (select id from books where user_id =3D 2454) group by 1 = order by 1 select * from logs where user_id =3D 1 and distributor_id =3D 2 and task = =3D 'Sales' and created_at > '11/14/19' order by id select date, min(created_at), max(created_at) from = barnes_and_noble_sales_points where date >=3D '11/1/19' and book_id in (select id from books where user_id =3D 1) group by 1 = order by 1</favourite> </favourites> > On Nov 14, 2019, at 11:40 PM, Praveen Agarwal = <[email protected]> wrote: >=20 > Hi Team, >=20 > I'm in dire need of help. > I was using pdgamin3 on macOS, recently after upgrading to = macOS-Catalina, pgadmin3 along with other apps are banned, I have set = lot of important queries in favourties, since its not opening now, is = there a way these favourites queries can be export from folder content. >=20 > Thanks & Regards, >=20 >=20 > Praveen Agarwal > Sr. Developer >=20 > +91-9958636699 >=20 > [email protected] <mailto:[email protected]> > <https://au.pinterest.com/twirll/> =20 > TWIRLL (www.twirll.com <http://www.twirll.com/>) - Powered by EBS = (www.ebsconsulting.biz <http://www.ebsconsulting.biz/>) > Please consider the environment before printing this email --Apple-Mail=_B4B2270B-AF4A-462C-9D3A-9CACA052B9A3 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; = charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; line-break: after-white-space;" class=3D"">I = just looked at my pgAdmin III configuration files (in ~) and there is an = XML file =E2=80=9C.pgadminfavourites=E2=80=9D that seems to contain = favorite queries. <div class=3D""><br class=3D""></div><div = class=3D""><div class=3D""><?xml version=3D"1.0" = encoding=3D"UTF-8"?></div><div class=3D""><favourites></div><div = class=3D""> <favourite title=3D"Test">select date, = sum(sold-returned) from barnes_and_noble_sales_points where date = &gt;=3D '11/1/19'</div><div class=3D"">and book_id in (select id = from books where user_id =3D 867) group by 1 order by 1</div><div = class=3D""><br class=3D""></div><div class=3D"">select = max(starting_date) from apple_trend_points where book_id in (select id = from books where user_id =3D 3893)</div><div class=3D""><br = class=3D""></div><div class=3D"">select starting_date, sum(qty) from = apple_trend_points where starting_date &gt;=3D '11/1/19'</div><div = class=3D"">and book_id in (select id from books where user_id =3D 1) = group by 1 order by 1</div><div class=3D""><br class=3D""></div><div = class=3D"">select date, sum(paid_sales + free_sales) from sales_points = where date &gt;=3D '11/1/19' and distributor_id =3D 3</div><div = class=3D"">and book_id in (select id from books where user_id =3D 2454) = group by 1 order by 1</div><div class=3D""><br class=3D""></div><div = class=3D"">select * from logs where user_id =3D 1 and distributor_id =3D = 2 and task =3D 'Sales' and created_at &gt; '11/14/19' order by = id</div><div class=3D""><br class=3D""></div><div class=3D"">select = date, min(created_at), max(created_at) from = barnes_and_noble_sales_points where date &gt;=3D '11/1/19'</div><div = class=3D"">and book_id in (select id from books where user_id =3D 1) = group by 1 order by 1</favourite></div><div = class=3D""></favourites></div><div><br class=3D""><blockquote = type=3D"cite" class=3D""><div class=3D"">On Nov 14, 2019, at 11:40 PM, = Praveen Agarwal <<a href=3D"mailto:[email protected]" = class=3D"">[email protected]</a>> wrote:</div><br = class=3D"Apple-interchange-newline"><div class=3D""><div dir=3D"ltr" = class=3D""><div class=3D""><span = style=3D"color:rgb(36,39,41);font-family:Arial,"Helvetica = Neue",Helvetica,sans-serif;font-size:15px" class=3D"">Hi = Team,</span></div><div class=3D""><span = style=3D"color:rgb(36,39,41);font-family:Arial,"Helvetica = Neue",Helvetica,sans-serif;font-size:15px" class=3D""><br = class=3D""></span></div><div class=3D""><span = style=3D"color:rgb(36,39,41);font-family:Arial,"Helvetica = Neue",Helvetica,sans-serif;font-size:15px" class=3D"">I'm in dire = need of help.</span></div><span = style=3D"color:rgb(36,39,41);font-family:Arial,"Helvetica = Neue",Helvetica,sans-serif;font-size:15px" class=3D"">I was using = pdgamin3 on macOS, recently after upgrading to macOS-Catalina, pgadmin3 = along with other apps are banned, I have set lot of important queries in = favourties, since its not opening now, is there a way these favourites = queries can be export from folder content.</span><br clear=3D"all" = class=3D""><div class=3D""><div dir=3D"ltr" class=3D"gmail_signature" = data-smartmail=3D"gmail_signature"><div dir=3D"ltr" class=3D""><br = class=3D"">Thanks & Regards,<br class=3D""><table = style=3D"font-size:12.8px;border:none;border-collapse:collapse" = class=3D""><colgroup class=3D""><col width=3D"90" class=3D""><col = width=3D"30" class=3D""><col width=3D"337" class=3D""></colgroup><tbody = class=3D""><tr style=3D"height:36pt" class=3D""><td rowspan=3D"4" = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:5pt" class=3D""><div style=3D"line-height: = 1.2; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size: 11pt; font-family: Arial; background-color: = transparent; vertical-align: baseline; white-space: pre-wrap;" = class=3D""><img = src=3D"https://lh5.googleusercontent.com/Ly-IExPqDkDQTuaGJYrmqAbeg-XJScmVh= KctyRmBHbAqt4YUyOM1SsUI4TzeMkVfDeLx1zTNtljDhoVlxxpFnT2yrPKh-tKjwQ5_CcKwBoZ= pP092ZkB60x7N49vfJsAk8kxmjxjG" width=3D"66" height=3D"73" alt=3D"twirll = logo for email signature-reduced.png" style=3D"border:none" = class=3D""></span></div><div style=3D"line-height: 1.2; margin-top: 0pt; = margin-bottom: 0pt;" class=3D""><span style=3D"font-size: 11pt; = font-family: Arial; background-color: transparent; vertical-align: = baseline; white-space: pre-wrap;" class=3D""><img = src=3D"https://lh6.googleusercontent.com/XOagqC9lF5duTgsxaTvdB7fkOqZpV3HMu= kgIZ4PhV7HEkDfaSIoQJr6HfPNTIJBNeUx7esm5ZUfrOxdHEVuWf-9KYzj3GeemD7C-syaQZ-K= asO43xBXBW1Bsq_jpqPv21f7voOlY" width=3D"67" height=3D"26" = style=3D"border:none" class=3D""></span></div></td><td colspan=3D"2" = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:0pt" class=3D""><div style=3D"line-height: = 1.38; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size:12pt;font-family:Arial;background-color:transparent;fon= t-weight:700;vertical-align:baseline;white-space:pre-wrap" = class=3D""><font color=3D"#0000ff" class=3D"">Praveen = Agarwal</font></span></div><div style=3D"line-height: 1.8; margin-top: = 0pt; margin-bottom: 0pt;" class=3D""><font color=3D"#0000ff" = face=3D"Arial" class=3D""><span = style=3D"font-size:13.3333px;white-space:pre-wrap" class=3D""><i = class=3D"">Sr. Developer</i></span></font></div></td></tr><tr = style=3D"height:17pt" class=3D""><td = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:0pt" class=3D""><div style=3D"line-height: = 1.2; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-s= pace:pre-wrap" class=3D""><img = src=3D"https://lh6.googleusercontent.com/rFnOxlKnkqu_K-rpGPH7yJpuqSKkrFIhG= fBZQ0ByNjxAFuRSAraWcca02QnCO9y6bqs08DHIwz9gjeKXJDaYt6CbdPv2e6041l-R68M1YRG= 9UpK7wNdup6xC9iKy3MkyA7D4s8HH" width=3D"20" height=3D"20" = alt=3D"phone-16.png" style=3D"border:none" = class=3D""></span></div></td><td = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:0pt" class=3D""><div style=3D"line-height: = 1.2; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size:8pt;font-family:Verdana;color:rgb(60,120,216);backgroun= d-color:transparent;vertical-align:baseline;white-space:pre-wrap" = class=3D"">+91-9958636699</span></div></td></tr><tr style=3D"height:21pt" = class=3D""><td = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:0pt" class=3D""><div style=3D"line-height: = 1.2; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-s= pace:pre-wrap" class=3D""><img = src=3D"https://lh5.googleusercontent.com/IIfcYk2PNkUyl1uwp7xQyQb-7ZgJiftVW= EG39WmoObWwcnQFNnO8LejKTnbhGFRIVcsbSVtfbfB-_pl9jtiOkFtQ-M5cpgUlWrIAmhbG6Yg= 8qoOghAGvO4ynl4OMVnk-7DjlvCdv" width=3D"20" height=3D"20" = alt=3D"mail-32.png" style=3D"border:none" class=3D""></span></div></td><td= = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:0pt" class=3D""><div style=3D"line-height: = 1.2; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><font = face=3D"Verdana" class=3D""><span = style=3D"font-size:10.6667px;white-space:pre-wrap" class=3D""><a = href=3D"mailto:[email protected]" target=3D"_blank" = class=3D"">[email protected]</a></span></font></div></td></tr><tr= style=3D"height:0pt" class=3D""><td colspan=3D"2" = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:0pt" class=3D""><div style=3D"line-height: = 1.2; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-s= pace:pre-wrap" class=3D""><img = src=3D"https://lh6.googleusercontent.com/BxNni5Nk3NzKU3Zn-X-s0RMmNxGyI20-F= nbtZ_N8u0wl4IImP42d2_gcUYCCOWW4jBmydTYpNzPRXXv2mPKlgU40HLRBuLkge617epWLWtN= LSEqsUB2q9zlRym-YZderp5cRnPjN" width=3D"24" height=3D"24" = alt=3D"linkedin.png" style=3D"border:none" class=3D""></span><span = style=3D"font-size: 11pt; font-family: Arial; vertical-align: baseline; = white-space: pre-wrap;" class=3D""> </span><span style=3D"font-size:= 11pt; font-family: Arial; vertical-align: baseline; white-space: = pre-wrap;" class=3D""><img = src=3D"https://lh5.googleusercontent.com/m2pbVtnSnSfI-dPiZ7OEUyYMrvJrLxPPS= f9z6SJBBdBf80S6X1lvcILFZmoWl3GD4zg-MexyHZl0snlnJ-VM7yRPkzPgRlCB4rbGZmYRe3F= nfj9mNHB9QFwgWjrGDsyHYCBQfe7O" width=3D"23" height=3D"23" = alt=3D"facebook.png" style=3D"border:none" class=3D""></span><span = style=3D"font-size: 11pt; font-family: Arial; vertical-align: baseline; = white-space: pre-wrap;" class=3D""> </span><span style=3D"font-size:= 11pt; font-family: Arial; vertical-align: baseline; white-space: = pre-wrap;" class=3D""><img = src=3D"https://lh4.googleusercontent.com/x9HrqeJ_LtOp9Wjm0r6TlOgcqEeg9Jr5C= RWNn1sRMGOi2V1fk8acNEWfEi1acWfCbR8K24auF39uGfz1hyDpBG74E08ICh_II4U1TUf4Jn9= Cmu926pZ8j_JmNtQVvprW0HXyih5I" width=3D"23" height=3D"23" = alt=3D"twitter.png" style=3D"border:none" class=3D""></span><span = style=3D"font-size: 11pt; font-family: Arial; vertical-align: baseline; = white-space: pre-wrap;" class=3D""> </span><span style=3D"font-size:= 11pt; font-family: Arial; vertical-align: baseline; white-space: = pre-wrap;" class=3D""><img = src=3D"https://lh4.googleusercontent.com/lqW0ekLarUDKPyl3VfNd30huN2kWlaUdk= WI33uFd6wE_JQWUhTLhuxsCmTZhs2VeiSnWi3kezntrfYjASOpBC28H-sUTMWWWlLR51v6FRzq= NKTvIy-arg-KNoy5uN3lrYpAEhBYA" width=3D"21" height=3D"21" = alt=3D"google_plus.png" style=3D"border:none" class=3D""></span><span = style=3D"font-size: 11pt; font-family: Arial; vertical-align: baseline; = white-space: pre-wrap;" class=3D""> </span><span style=3D"font-size:= 11pt; font-family: Arial; vertical-align: baseline; white-space: = pre-wrap;" class=3D""><img = src=3D"https://lh5.googleusercontent.com/6Fa_2cNWZwZ4mi45yH4rzCP8bcXEvZdXu= nUmKdKtMXQpsZlKGMk1GGhAKcrl9DgY90m7W6zVcfqf_tEC_9IbZnJX6KH62vLnaNL55XKM8sx= CXfrhqK3EH7TsYMi3xvt0Gami4X29" width=3D"21" height=3D"21" = alt=3D"instagram.png" style=3D"border:none" class=3D""></span><a = href=3D"https://au.pinterest.com/twirll/" target=3D"_blank" = class=3D""><span style=3D"font-size: 11pt; font-family: Arial; = vertical-align: baseline; white-space: pre-wrap;" class=3D""> = </span><span style=3D"font-size: 11pt; font-family: Arial; = vertical-align: baseline; white-space: pre-wrap;" class=3D""><img = src=3D"https://lh3.googleusercontent.com/bQOaNJtH2VT-WH6RBHVL1N8pRXM_LZrTn= W7k1XpELkbltaV6P_slqV8Beeua204uKvugPgpZouU1-NIAOlB0tJ7fIG18nrORzxvYRfVX7MA= GndZDysI_rAbyq0Nj4NLss98hfAzc" width=3D"22" height=3D"22" = alt=3D"pinterest.png" style=3D"border:none" class=3D""></span></a><span = style=3D"font-size: 11pt; font-family: Arial; vertical-align: baseline; = white-space: pre-wrap;" class=3D""> </span></div></td></tr><tr = style=3D"height:0pt" class=3D""><td colspan=3D"3" = style=3D"border-width:0pt;border-style:solid;border-color:rgb(255,255,255)= ;vertical-align:middle;padding:3pt" class=3D""><div style=3D"line-height: = 1.728; margin-top: 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size:7pt;font-family:Verdana;color:rgb(60,120,216);font-styl= e:italic;vertical-align:baseline;white-space:pre-wrap" class=3D"">TWIRLL = (</span><a href=3D"http://www.twirll.com/" target=3D"_blank" = class=3D""><span = style=3D"font-size:7pt;font-family:Verdana;color:rgb(17,85,204);font-style= :italic;vertical-align:baseline;white-space:pre-wrap" = class=3D"">www.twirll.com</span></a><span = style=3D"font-size:7pt;font-family:Verdana;color:rgb(60,120,216);font-styl= e:italic;vertical-align:baseline;white-space:pre-wrap" class=3D"">) - = Powered by EBS (</span><a href=3D"http://www.ebsconsulting.biz/" = target=3D"_blank" class=3D""><span = style=3D"font-size:7pt;font-family:Verdana;color:rgb(17,85,204);font-style= :italic;vertical-align:baseline;white-space:pre-wrap" = class=3D"">www.ebsconsulting.biz</span></a><span = style=3D"font-size:7pt;font-family:Verdana;color:rgb(60,120,216);font-styl= e:italic;vertical-align:baseline;white-space:pre-wrap" = class=3D"">)</span></div><div style=3D"line-height: 1.728; margin-top: = 0pt; margin-bottom: 0pt;" class=3D""><span = style=3D"font-size:7pt;font-family:Verdana;color:rgb(0,128,0);font-style:i= talic;vertical-align:baseline;white-space:pre-wrap" class=3D"">Please = consider the environment before printing this = email</span></div></td></tr></tbody></table></div></div></div></div> </div></blockquote></div><br class=3D""></div></body></html>= --Apple-Mail=_B4B2270B-AF4A-462C-9D3A-9CACA052B9A3--