copying table to a file

From: Tyler Robert Wood <twood(at)csd(dot)uwm(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: copying table to a file
Date: 2000-06-16 19:57:13
Message-ID: Pine.OSF.3.96.1000616145446.30115A-100000@alpha2.csd.uwm.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)uwm(dot)edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Caskey 2000-06-16 20:01:10 Bigger sequences (int8)
Previous Message Thomas Good 2000-06-16 17:14:26 Re: Perl interface