Thread: Is there a way to export favourites from pgadmin3 on Lates macOS version(Catalina)
Is there a way to export favourites from pgadmin3 on Lates macOS version(Catalina)
From
Praveen Agarwal
Date:
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 | ||
TWIRLL (www.twirll.com) - Powered by EBS (www.ebsconsulting.biz) Please consider the environment before printing this email |
Re: Is there a way to export favourites from pgadmin3 on Lates macOSversion(Catalina)
From
Jack Royal-Gordon
Date:
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.agarwal@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 AgarwalSr. Developer +91-9958636699 Please consider the environment before printing this email