Skip site navigation (1) Skip section navigation (2)

Re: copy import csv problem

From: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
To: Peter Lowman <itsasecret4(at)bigpond(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: copy import csv problem
Date: 2002-04-15 14:12:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hash: SHA1

So now you look and see if user 26 has read access to /home, /home/peter,
/home/peter/vests.csv. This is normal Unix permissions problem.

Joshua b. Jore

On Sun, 14 Apr 2002, Peter Lowman wrote:

> Have only just installed RH7.2 and pgsql
> I'm trying to import an access csv file have already setup db with
> necessary columns.
> COPY wests from '/home/peter/wests.csv' using delimiters ';';
> ERROR: COPY command, running in background with effective uid 26, could
> not open file '/home/peter/wests.csv' for reading. Errno = Permission
> denied (13).
> I can view the file with editors etc.  I'v tried su postgres, same result.
> How can can I get permission?
> Peter
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see


In response to

pgsql-novice by date

Next:From: Oliver ElphickDate: 2002-04-15 14:18:48
Subject: Re: Problem in postgresql installation
Previous:From: RobDate: 2002-04-15 14:04:10
Subject: Referential Integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group