Must be superuser or a member of the pg_write_server_files role to COPY to a file, how to decide?

Question

PostgreSQL

When trying to copy the database to your folder:

COPY (SELECT ROW_TO_JSON(t)
FROM (SELECT * FROM item) t)
TO '/project/database';

Gives me an error:

Must be superuser or a member of the pg_write_server_files role to COPY to a file

Where is the error here and how can the above code be corrected?
Thank you in advance

Answer 1

This is not an error, but a reminder that superusers and members of the corresponding role can upload something to files. Are you sure that's what you want, and not, for example, redirecting the result of a query to a file on the client?

Answer 2

you must be a superuser
or a member of the group
pg_write_server_files role Solved
by adding your role to this group and giving it rights to the
/project/database folder at the OS level