On Sat, Oct 3, 2015 at 1:43 PM, dinesh kumar wrote: > We can also use "PROGRAM 'cat > Output.csv' " to achieve this "NO READ > ACCESS", since the program is always running as a instance owner. > Let me know your inputs and thoughts.
That's one way. And as PROGRAM presents the advantage to open the file before the COPY has begun processing any tuples, the umask would be set before writing any data to it, hence why complicating COPY with a new option while we already have something to apply restrictions to the output file? It seems that this patch is just an unnecessary complication, and I doubt that we would want to change the default behavior of 644 that has been here for ages. -- Michael -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers