From: | adam_pgsql <adam_pgsql(at)witneyweb(dot)org> |
---|---|
To: | ria ulfa <riakdr(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: ask...!!! |
Date: | 2008-07-01 09:31:20 |
Message-ID: | 733A7022-0E2A-42C1-BEF5-30CE6E319A9D@witneyweb.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Bräutigam | 2008-07-01 11:50:10 | Re: Recommended RAID for Postgres |
Previous Message | Achilleas Mantzios | 2008-07-01 09:21:14 | Re: ask...!!! |