Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0A4FB6328BA for ; Fri, 25 Jun 2010 22:51:36 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 42399-09 for ; Sat, 26 Jun 2010 01:51:27 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id 9B34C62EDA7 for ; Fri, 25 Jun 2010 22:51:28 -0300 (ADT) Received: by pxi8 with SMTP id 8so962300pxi.19 for ; Fri, 25 Jun 2010 18:51:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:reply-to:to:subject:date :user-agent:cc:references:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:message-id; bh=umHw3wGHsz5S+qsM2Qaj6hGrRBS93KnzQhLnU0W7Z6Q=; b=MfBw0RGxGtil+nRNflBQqiQMwG2/1SI8MSGlF6re29qZ3DoWIJj4c/ADbxQMfi5gvN nP5BoyXlkRl1ivANy26hmtDlQB2JTxfbzV8Q0tDPB3ZVQ0CXrfjk9nTHa0Us0mZtScy4 PPaZ6SvyB6gCkP820tBpTFvvHrv66kzXL9cWQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:reply-to:to:subject:date:user-agent:cc:references:in-reply-to :mime-version:content-type:content-transfer-encoding :content-disposition:message-id; b=OUBmfKfJ5tfJpc1HHxlvqM2ETMD3tXFoppYUEyVOktn6darAEFz2gcaj9+DjBQbPDh Cmjixie1hqw87nYFFkQ/p5uRFIRlXC00bC+5Pipsh3Lf/hJkNMIuOiBaMX4OvCngq/t3 MHTlBhh5vdX4REK54RwQ/b/d6w6PbYCm3oKmQ= Received: by 10.143.153.23 with SMTP id f23mr1947284wfo.64.1277517085668; Fri, 25 Jun 2010 18:51:25 -0700 (PDT) Received: from tucker.local (c-24-17-164-54.hsd1.wa.comcast.net [24.17.164.54]) by mx.google.com with ESMTPS id g14sm860137rvb.6.2010.06.25.18.51.25 (version=SSLv3 cipher=RC4-MD5); Fri, 25 Jun 2010 18:51:25 -0700 (PDT) From: Adrian Klaver Reply-To: adrian.klaver@gmail.com To: Bruno Scovoli Santos Subject: Re: COPY command and required file permissions Date: Fri, 25 Jun 2010 18:51:26 -0700 User-Agent: KMail/1.9.10 Cc: pgsql-sql@postgresql.org References: <4C24F765.40008@gmail.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <201006251851.26366.adrian.klaver@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.5 tagged_above=-5 required=5 tests=BAYES_05=-0.5, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/103 X-Sequence-Number: 34294 On Friday 25 June 2010 6:07:35 pm Bruno Scovoli Santos wrote: > * Are you connecting to the database as a superuser to run the COPY > command? * > > Yes. This \copy command is in the database build script (create table > blablabla....). So it almost (I think) must have to be a superuser. > > But hey, my intent was just to guide the guy (Harold A. Gim=E9nez Ch.) to > follow my practice (to use a preceding backslash). I dont bother to have = to > add that preceding backslash in my script. ;-) > > Actually my question was directed to Harold, I put my reply in the wrong pl= ace. In any case COPY and \copy are different commands. COPY is done from the=20 server's perspective, \copy from the clients. Hence the permission issues w= ill=20 be different. See below for more detail. http://www.postgresql.org/docs/8.4/interactive/sql-copy.html http://www.postgresql.org/docs/8.4/interactive/app-psql.html =2D-=20 Adrian Klaver adrian.klaver@gmail.com