Re: run COPY as user other than postgres

On Tue, Apr 23, 2013 at 1:11 PM, Kirk Wythers <wythe001@umn.edu> wrote:
> I would like to run the COPY command as a user other than "postgres". I find it a bit of a pain (or at least
requiringan extra step or two) to have the postgres user own the files that I am creating with COPY TO. Here is a
simpleexample where the location '/some/path/to/file/file.csv' is owned by another user and it would be very spiffy if
Icould run the COPY TO as that user. Any ideas? 

sudo chown anotheruser:postgres /some/path/to/file/file.csv
sudo chmod 664 /some/path/to/file/file.csv

This will set the file's group to postgres and allow it's members to
write to the file.

>
>
>
> COPY (
>         SELECT * FROM
>                 some_table
>         WHERE
>                 2012 = EXTRACT (YEAR FROM some_column) --AND value IS NOT NULL
> )
>         TO '/some/path/to/file/file.csv' WITH CSV HEADER;
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



--
Kind regards,
Sergey Konoplev
Database and Software Consultant

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray.ru@gmail.com