copying table to a file - Mailing list pgsql-general

From Tyler Robert Wood
Subject copying table to a file
Date
Msg-id Pine.OSF.3.96.1000616145446.30115A-100000@alpha2.csd.uwm.edu
Whole thread Raw
Responses Re: copying table to a file  (Trurl McByte <trurl@realtor3d.odessa.ua>)
List pgsql-general
Hi,
I am attempting to copy the contents of a table to a file, like this:

foodserver=> COPY company TO '/home/peter/copytest.out';


But I keep getting this error:

ERROR:  COPY command, running in backend with effective uid 100, could not
open file '/home/peter/copytest.out' for writing.  Errno = Permission
denied (13).

Does anybody know how I can fix this so I have permission to open files?

Thanks,

Tyler Wood
twood@uwm.edu


pgsql-general by date:

Previous
From: Thomas Good
Date:
Subject: Re: Perl interface
Next
From: Giles Lean
Date:
Subject: Re: optimization by removing the file system layer?