Export query result from pgadmin to excel file

sql postgresql pgadmin
saltlife31496 picture saltlife31496 · Mar 29, 2016 · Viewed 9.3k times · Source

I am trying to export the result from a query in pgadmin to a excel file i have tried:

COPY (Select * From SYSTEMS) To '/tmp/test.csv' With CSV;

but it returns the error:

ERROR: must be superuser to COPY to or from a file

Answer

nayaganov picture nayaganov · Feb 27, 2020

pgadmin, running under "pgadmin system user" can't accese to /tmp/ catalog. You need to grant access for postgres user or all users for /tmp/ catalog.

Related questions

How to visualize database tables in postgresql using pgAdmin?

I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a query visualizer tool available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to …

Read More
Create an ER diagram in pgAdmin

What would be the step by step walk-through for building a basic Entity-Relationship Diagram from pgAdmin? Would there be some plugins for doing that in pgAdmin? Note: I searched in the web but other than stumbling upon an exhausting list …

Read More
How restore postgreSQL dump file using pgAdmin?

I've a .dmp file. Want to restore the database from it. Using pgAdmin how can I do it?

Read More