| 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: | Whole Thread | Raw Message | 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=#
------
| 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: |