Postgres Pro
Downloads
Home   >   mailing lists

Re: On Postgres and permissions, cant read a file into a table - Mailing list pgsql-novice

From Tom Lane
Subject Re: On Postgres and permissions, cant read a file into a table
Date
Msg-id 11336.985538887@sss.pgh.pa.us
Whole thread Raw
In response to On Postgres and permissions, cant read a file into a table  (Lars Forseth <larsf@powertech.no>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Lars Forseth
Date:
Subject: On Postgres and permissions, cant read a file into a table
Next
From: Tom Lane
Date:
Subject: Re: how do I CHECK 'field only contains characters 0-9 or space?'