Re: Is there a way to export favourites from pgadmin3 on Lates macOS version(Catalina)

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 &gt;= '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 &gt;= '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 &gt;= '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 &gt; '11/14/19' order by id

select date, min(created_at), max(created_at) from barnes_and_noble_sales_points where date &gt;= '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(dot)agarwal(at)twirll(dot)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(dot)agarwal(at)twirll(dot)com <mailto:praveen(dot)agarwal(at)twirll(dot)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