SQL Manager: How to move favorite queries to another database

Asked Mar 01 '19 at 18:11

Active Mar 02 '19 at 05:38

Viewed 47 times

I use SQL Manager with PostgreSQL 9.3.18, and I have to restore the main database, located on server, to a new local DB every week. Ending up with 4 databases the last week of each month. I have a bunch of favorite queries that I need them in all restored in the local databases. Each time that I make a restored DB, I have to create the favorite queries one by one. Is there any way to move them to another database easily.

enter image description here

edited Mar 02 '19 at 05:38

Laurenz Albe

209,280
17
206
263

asked Mar 01 '19 at 18:11

Ms workaholic

What is a favorite query in a database? Is that a feature of some client application? – Laurenz Albe Mar 01 '19 at 20:17
No, in SQL Manager for PostgreSQL if you connect to a DB and scroll down you see the fav. queries. I'll add an image to show that. – Ms workaholic Mar 01 '19 at 23:40
That was the missing information! Your question is not about PostgreSQL at all. I have edited it to clarify that. – Laurenz Albe Mar 02 '19 at 05:39

SQL Manager: How to move favorite queries to another database

0 Answers0