While Using COPY COMMAND ...

From: Bhuvan A <bhuvanbk(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: While Using COPY COMMAND ...
Date: 2001-07-06 06:35:22
Message-ID: Pine.LNX.4.20.0107061153150.10925-100000@Larry.bks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hello sirs,,

I am using PSQL client. I can able to copy the contents of a
table to '/tmp/' directory. But Why can't i able to copy
contents of a table to my home directory?

But, i can redirect the output of a command (\o) to a file
in my home directory.. How it gets succeed while the prev.
doesn't????

For your clarifications, here is the workflow.

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).
bhuvan=# copy f_addr_phones with oids to '/tmp/fap-table';
COPY
bhuvan=#

------

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-07-06 07:07:14 Re: ConnecDB() -- couldn't send SSL negotiation packet:
Previous Message Bhuvan A 2001-07-06 04:42:10 Re: ConnecDB() -- couldn't send SSL negotiation packet: