Re: Permissions on file created by COPY TO

Joel Shellman <joel(at)ikestrel(dot)com> writes:
> Of I run a COPY TO command it creates a file. What determines the
> permissions of that file? The created file is owned by postgres, but I
> need a different user to be able to manipulate it (actually, I just want
> to delete it). So I thought to make it group writable so the other user
> could be in postgres group and delete the file.

Uh, deletion has nothing to do with writability of the file, and
everything to do with writability of the directory it's in. So you
could solve the stated problem without touching the Postgres code.

However, the answer to your question is that the mode is hardwired to
644 (rw-r--r--) by the umask call in src/backend/commands/copy.c.

regards, tom lane