That usually means that the database user doesn't have Windows file level permissions to write to that folder. Maybe when you upgraded to pgadmin 1.6 and now are using a different user id to log into the it? Perhaps the destination directory was c: \postgresql\8.1\data before? Mike On Thu, 2007-01-04 at 03:28 +0100, Tomas Lanczos wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq
