Re: ask...!!!

Hello,

I don't think it's a good idea to store it under the /root directory,
since "normal" users like e.g. postgres don't have write permission
there (as the error message tells you).
You have to choose a directory where your database user definitely has
write permission.

bye-GERD-

ria ulfa schrieb:
> 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??
>