copying table to a file

Tyler Robert Wood <twood@csd.uwm.edu>

From: Tyler Robert Wood <twood@csd.uwm.edu>
To: pgsql-general@postgresql.org
Date: 2000-06-16T19:57:13Z
Lists: 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