Received: from johann.inet.co.th (nuchk@johann.inet.co.th [203.150.17.140]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA16631; Wed, 15 Sep 1999 00:22:13 -0400 (EDT) (envelope-from nuchk@inet.co.th) Received: from localhost (nuchk@localhost) by johann.inet.co.th (8.9.0/8.9.0) with ESMTP id LAA04233; Wed, 15 Sep 1999 11:21:49 +0700 (GMT+0700) X-Authentication-Warning: johann.inet.co.th: nuchk owned process doing -bs Date: Wed, 15 Sep 1999 11:21:48 +0700 (GMT+0700) From: Nuchanach Klinjun To: =?iso-8859-1?Q?St=E9phane_FILLON?= cc: pgsql-sql , pgsql-hackers , pgsql-general Subject: Re: [HACKERS] Permission problem with COPY FROM In-Reply-To: <000e01befedd$3e2210c0$a6373ad1@portable> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id AAB16676 Hi, I've faced that problem too, then I use '\copy' instread of 'copy' because 'copy' command will asked for super user previlege. example ^^^^^^ -> \copy '/your location/your filename' to tablename; Cheers, On Wed, 15 Sep 1999, [iso-8859-1] Stéphane FILLON wrote: > Hi, > > Each time I try to insert an ascii file with the COPY FROM command, I get the following message: > > "ERROR: COPY command, running in backend with effective uid 501 (that's Postgres), could not open file '/usr/local/.../cltclr001' for reading. Error: Permission not allowed (13)." > > What rights do I have to put to process the COPY command inside PSQL. > > I have try nearly everything, actual rights: uog+rw even on the directory. > > > What's wrong. > > Stephane FILLON > ----------------------------------------- Nuchanach Klinjun R&D Project. Internet Thailand Email: nuchk@inet.co.th