PostgreSQL 7.3 - using Copy command

[dgill]

Here's the error I get when i attempt a Copy command to load data into an existing Table:

dgdb=# copy customer from '/Users/dg/Desktop/Customers.txt';

ERROR: COPY command, running in backend with effective uid 502, could not open file '/Users/dg/Desktop/Customers.txt' for reading. Errno = Permission denied (13).

What am I doing wrong? I'm quite new to all of this UNIX stuff, so any help would be appreciated.

 

[dgill]

I found the problem. Instead of using:

dgdb=# copy customer from '/Users/dg/Desktop/Customers.txt';

I instead tried:

dgdb=# copy customer from '/Users/dg/Customers.txt';

This works just fine.