Re: COPY command error in psql. - Mailing list pgsql-general

From Matthew Stanfield
Subject Re: COPY command error in psql.
Date
Msg-id 3CB2FD2B.180A46ED@propertyknowledge.com
Whole thread Raw
In response to COPY command error in psql.  (Matthew Stanfield <matthew@propertyknowledge.com>)
List pgsql-general
> > Now I understand why this happened the first time I ran the command as only
> > user 'ms' had any kind of permission for AB.csv.
>
> What about permissions on the containing directories?  That path
> requires search (x) permission on each directory traversed to reach the
> file...

That's right it was a directory permission problem.

Many thanks for your replies,

Matthew

pgsql-general by date:

Previous
From: "Jeffrey W. Baker"
Date:
Subject: Re: more about pg_toast growth
Next
From: Fran Fabrizio
Date:
Subject: Cannot execute null query