Received: from Donald.bks ([202.9.161.100]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f666ZQa40611 for ; Fri, 6 Jul 2001 02:35:27 -0400 (EDT) (envelope-from bhuvanbk@yahoo.com) Received: from Larry.bks (root@Larry.bks [200.2.1.10]) by Donald.bks (8.11.3/8.11.3) with ESMTP id f666biV09519 for ; Fri, 6 Jul 2001 12:07:45 +0530 Received: from localhost (bhuvan@localhost) by Larry.bks (8.9.3/8.8.5) with ESMTP id MAA27817 for ; Fri, 6 Jul 2001 12:05:22 +0530 Date: Fri, 6 Jul 2001 12:05:22 +0530 (IST) From: Bhuvan A To: pgsql-sql@postgresql.org Subject: While Using COPY COMMAND ... In-Reply-To: <005201c103dc$0b82e260$1001a8c0@archonet.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200107/52 X-Sequence-Number: 3833 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=# ------