Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I save a query in pgAdmin 4?

Tags:

How do I save a query in pgAdmin 4? No matter where I try to save it within the PostgreSQL file or the pgAdmin 4 file, the result is that I do not have access.

C:\Program Files\PostgreSQL\9.6\pgAdmin 4\

I have tried both bin files, data files, and many other files.

It always says that I don't have access.

I see that I can save data output as a CSV file, but I want the actual query.

If I close pgAdmin, I lose everything in the query.

like image 529
Katydid Avatar asked Jan 24 '17 04:01

Katydid


1 Answers

I assuming that query means that you type query in Query tool.

Default location: C:\Users\YOUR_USERNAME_HERE\AppData\Roaming\pgAdmin\storage

enter image description here

enter image description here

like image 130
Murtuza Z Avatar answered Sep 22 '22 12:09

Murtuza Z