Permissions on file created by COPY TO - Mailing list pgsql-general

From Joel Shellman
Subject Permissions on file created by COPY TO
Date
Msg-id 1014670190.6678.98.camel@localhost.localdomain
Whole thread Raw
In response to Re: Backup & Restore  (Doug McNaught <doug@wireboard.com>)
Responses Re: Permissions on file created by COPY TO
List pgsql-general
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.

Thank you,
--
Joel Shellman
Comprehensive Internet Solutions -- Building business dreams.
[ web design | database | e-commerce | hosting | marketing ]
iKestrel, Inc.  http://www.ikestrel.com/


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Backup & Restore
Next
From: Gavin Scott
Date:
Subject: Defunct postmasters