I just looked at my pgAdmin III configuration files (in ~) and there is an XML file “.pgadminfavourites” that seems to contain favorite queries.
<?xml version="1.0" encoding="UTF-8"?> <favourites> <favourite title="Test">select date, sum(sold-returned) from barnes_and_noble_sales_points where date >= '11/1/19' and book_id in (select id from books where user_id = 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 = 3893) select starting_date, sum(qty) from apple_trend_points where starting_date >= '11/1/19' and book_id in (select id from books where user_id = 1) group by 1 order by 1 select date, sum(paid_sales + free_sales) from sales_points where date >= '11/1/19' and distributor_id = 3 and book_id in (select id from books where user_id = 2454) group by 1 order by 1 select * from logs where user_id = 1 and distributor_id = 2 and task = '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 >= '11/1/19' and book_id in (select id from books where user_id = 1) group by 1 order by 1</favourite> </favourites> > On Nov 14, 2019, at 11:40 PM, Praveen Agarwal <praveen.agar...@twirll.com> > wrote: > > Hi Team, > > 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. > > Thanks & Regards, > > > Praveen Agarwal > Sr. Developer > > +91-9958636699 > > praveen.agar...@twirll.com <mailto:praveen.agar...@twirll.com> > <https://au.pinterest.com/twirll/> > 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
