Received: from Donald.bks ([202.9.161.100]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f668d0a33333 for ; Fri, 6 Jul 2001 04:39:01 -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 f668fCV10003; Fri, 6 Jul 2001 14:11:16 +0530 Received: from localhost (bhuvan@localhost) by Larry.bks (8.9.3/8.8.5) with ESMTP id OAA26721; Fri, 6 Jul 2001 14:08:48 +0530 Date: Fri, 6 Jul 2001 14:08:48 +0530 (IST) From: Bhuvan A To: David Stanaway cc: pgsql-sql@postgresql.org Subject: Re: While Using COPY COMMAND ... In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200107/54 X-Sequence-Number: 3835 hello sirs,, the permission of '/tmp/' directory is drwxrwxrwt 41 root root 12288 Jul 6 14:01 /tmp/ the permission of the file copied to '/tmp/' directory is -rw-r--r-- 1 postgres users 399 Jul 6 12:01 /tmp/fap-table Sir, as you mentioned if it is not possible to copy to a home directory, then how can we able to redirect the result of some queries to any possible file in home directory!!??? Example: bhuvan=# \o select-output bhuvan=# select * from stdcodes; bhuvan=# NOTE: I am really new to postgres, kindly apologize for any inconvince in my submission. Thanking you, Yours truly, Bhuvaneswar. On Fri, 6 Jul 2001, David Stanaway wrote: > > On Friday, July 6, 2001, at 04:35 PM, Bhuvan A wrote: > > > > > 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? > > My guess is that user/group postgres can't write to your home directory. > > Who owns the file you copied to /tmp ? > > -- > Best Regards > David Stanaway > ========================.--------------------------------------------- > Technology Manager - Australia's Premier Internet Broadcasters > david@NetVentures.com.au Office +612 9357 1699 > ========================'--------------------------------------------- >