Export query result from pgadmin file for Excel

Question

I am trying to export the result from a request in pgadmin to an excel file that I tried:

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

but it returns an error:

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

Answer 1

In pgAdmin4, you can create a new server with superuser privileges:

1) For example, for pgAdmin4 for Windows, right-click "Servers" in the "Browser" window> Click "Create", then "Server".

2) "" "" > "" " ". " " , "postgres" "".

3) "".

, " " . . .