You need to output it into a directory you have permission to write to. Either change the permissions on documents, or write it into somewhere you definately do have permissions (e.g. /tmp/log.sql) and then move it to the desired location.
----- Original 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=# COPY log TO '/root/documents/log.sql';
note= simps: name of database
but there is error: could not open file "/root/documents/log.sql" for writing: Permission denied
what can i do for repair this error??
Not happy with your email address?
Get the one you really want - millions of new email addresses available now at
Yahoo!