> On 2013-04-23, Kirk Wythers <wythe...@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 requiring an extra step or two) to > > have the postgres user own the files that I am creating with COPY TO. Here > > is a simple example where the location '/some/path/to/file/file.csv' is > > owned by another user and it would be very spiffy if I could run the COPY > > TO as that user. Any ideas?
Write your own client that uses the copy interface to load a file from wherever and send it to the server. Or just use the one built in to psql, as Jasen suggested. -- Bill Moran <wmo...@potentialtech.com> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general