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>
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 |
| |
|
Please consider the environment before printing this email |