Στις Tuesday 01 July 2008 11:12:39 ο/η ria ulfa έγραψε:
> 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??
>
The best thing you can do is get yourself familiar with a UNIX environment.
Apparently the user on behalf of which, you run psql, cannot write to /root/documents/log.
--
Achilleas Mantzios