Re: On Postgres and permissions, cant read a file into a table

Lars Forseth <larsf@powertech.no> writes:
> "COPY "Gravtype" FROM '/home/larsf/DATA/gravtype.txt' USING DELIMITERS '"'

> PostgreSQL error mesage:
> ERROR: COPY command, running in backend with effective uid 26 could not open
> file '/home/larsf/DATA/gravtype.txt' for reading. Errno = Permission denied
> (13)."

Are the permissions on /home/larsf and /home/larsf/DATA set to allow
user postgres to do lookups in those directories?

            regards, tom lane