Re: ask...!!!

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(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)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