Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 98F4D650F27 for ; Tue, 1 Jul 2008 07:00:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06945-01 for ; Tue, 1 Jul 2008 06:59:20 -0300 (ADT) X-Greylist: delayed 00:06:38.996331 by SQLgrey-1.7.6 Received: from web25805.mail.ukl.yahoo.com (web25805.mail.ukl.yahoo.com [217.12.10.190]) by postgresql.org (Postfix) with SMTP id D6154650ECE for ; Tue, 1 Jul 2008 06:24:58 -0300 (ADT) Received: (qmail 76971 invoked by uid 60001); 1 Jul 2008 09:18:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=eBGrSldVa+z1QwYQTIbIWHQiki9QjQ1n3N3p332efXplI/haoJxml+xyh3D0XjSH/5/+IDOOaljwRJTAu0hAOyJib7dMBc9l+e935exFV6mRkjSLyF5JbAgvmG94xG1vlq41WP+LneZPvxVLxxA/tOLJyFs/6SUw/yocHaHNU9s=; Received: from [213.83.65.106] by web25805.mail.ukl.yahoo.com via HTTP; Tue, 01 Jul 2008 09:18:13 GMT X-Mailer: YahooMailRC/1042.24 YahooMailWebService/0.7.199 Date: Tue, 1 Jul 2008 09:18:13 +0000 (GMT) From: Glyn Astill Subject: Re: ask...!!! To: ria ulfa , pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-332095541-1214903893=:76536" Message-ID: <154381.76536.qm@web25805.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/10 X-Sequence-Number: 29620 --0-332095541-1214903893=:76536 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable You need to output it into a directory you have permission to write to.=0AE= ither change the permissions on documents, or write it into somewhere=0Ayou= definately do have permissions (e.g. /tmp/log.sql) and then move it=0Ato t= he desired location.=0A=0A=0A----- Original Message ----=0AFrom: ria ulfa <= riakdr@gmail.com>=0ATo: pgsql-admin@postgresql.org=0ASent: Tuesday, 1 July,= 2008 9:19:41 AM=0ASubject: [ADMIN] ask...!!!=0A=0A=0A=0Ai use linux fedora= 7 and database PostgreSQL 8.=0Ai want to copy table in postgre to a file.= =0Ai used code : simps=3D# COPY log TO '/root/documents/log.sql';=0A n= ote=3D simps: name of database=0Abut there is error: could not open file "= /root/documents/log.sql" for writing: Permission denied=0Awhat can i do for= repair this error?? =0A=0A=0A=0A ____________________________________= ______________________=0ANot happy with your email address?.=0AGet the one = you really want - millions of new email addresses available now at Yahoo! h= ttp://uk.docs.yahoo.com/ymail/new.html --0-332095541-1214903893=:76536 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
You need to output it into a directory you have permis= sion to write to.=0AEither change the permissions on documents, or write it= into somewhere=0Ayou definately do have permissions (e.g. /tmp/log.sql) an= d then move it=0Ato the desired location.

----- Or= iginal Message ----
From: ria ulfa <riakdr@gmail.com>
To: pgsql= -admin@postgresql.org
Sent: Tuesday, 1 July, 2008 9:19:41 AM
Subject:= [ADMIN] ask...!!!


i use linux fedora= 7 and database PostgreSQL 8.
i want to copy table in postgre to a file.=
i used code : simps=3D# COPY log TO '/root/documents/log.sql';
 = ;     note=3D simps: name of database
=0A=0Abut ther= e is error:  could not open file "/root/documents/log.sql" for writing= : Permission denied
what can i do for repair this error??=0A

= =0A

=0A=0A=0A=0A
=0ANot happy with = your email address?=0A
Get the one you =0A=0Areally want - millions of new email addresse= s available now at Yahoo! --0-332095541-1214903893=:76536--