could not open file xxxx for writing: Permission denied

From: "Tomas Lanczos" <lanczos(at)t-zones(dot)sk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: could not open file xxxx for writing: Permission denied
Date: 2007-01-04 02:28:47
Message-ID: 004601c72fa8$1061e210$2201a8c0@tomas
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Using PostgreSQL 8.1.4, pgadmin III 1.6.0 in WinXP I tried to export a table
using COPY (first time in postgresql, did many times in Sybase):

COPY ml50jtsk_datum_v TO 'c:/postgresql/ml50jtsk.out';

I got the following errormessage:

ERROR: could not open file "c:/postgresql/ml50jtsk.out" for writing:
Permission denied
SQL state: 42501

What's wrong? Does it mean that the database user has no writing permission
out of the database? How I did a pg_dump then few weeks ago?

Many thanks for help and/or explanation, best regards and Happy New Year

Tomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mike 2007-01-04 04:27:44 Re: could not open file xxxx for writing: Permission
Previous Message felix 2007-01-04 01:59:24 Tabbed data in tab-separated output