While Using COPY COMMAND ...

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=# 

------