Re: ask...!!!

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

In response to

  • ask...!!! at 2008-07-01 08:18:59 from ria ulfa

Browse pgsql-admin by date

  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...!!!