Re: While Using COPY COMMAND ... - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: While Using COPY COMMAND ...
Date
Msg-id Pine.LNX.4.30.0107061617580.679-100000@peter.localdomain
Whole thread Raw
In response to While Using COPY COMMAND ...  (Bhuvan A <bhuvanbk@yahoo.com>)
List pgsql-sql
Bhuvan A writes:

> bhuvan=# copy f_addr_phones with oids to
> '/home/bhuvan/fap-table';
> ERROR:  COPY command, running in backend with effective uid
> 1015, could not open file '/home/bhuvan/fap-table' for
> writing.  Errno = Permission denied (13).

The server is probably running under a different user id (postgres?).

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: "postgresql"
Date:
Subject: finding current oid
Next
From: Jan Wieck
Date:
Subject: Re: [GENERAL] Cross database foreign keys