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 <[EMAIL PROTECTED]>
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! http://uk.docs.yahoo.com/ymail/new.html
