How do I save a query in pgAdmin 4?

pgadmin-4
Katydid picture Katydid · Jan 24, 2017 · Viewed 20.8k times · Source

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.

Answer

Murtuza Z picture Murtuza Z · Jan 25, 2017

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

Related questions

pgadmin4 : postgresql application server could not be contacted.

I have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_…

Read More
FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's asking me to input password, and I haven't put any …

Read More
PgAdmin4 unable to query or view data

I have a very basic PostgreSql table. Despite the simple table schema, I cannot query it via PgAdmin4. The View Data option is unresponsive; Query Tool option becomes unresponsive after a few attempts in opening and closing the panel. When …

Read More