On 1 Jul 2008, at 09:18, ria ulfa wrote:
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??
you don't have permission to write to that file... either change the
permissions on the file or write to a file or directory in which you
do have permission, maybe to your home directory or something
adam