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: Pine.BSO.4.40.0204150911090.13559-100000@kitten.greentechnologist.org (view raw or flat)
Thread:
Lists: pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
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
http://www.greentechnologist.org

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
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8ut+8fexLsowstzcRAmD5AJ456uAplApSR2Jjdmxl7TjQyTwzewCeK0fF
DW8ekZz4FPEv8OTavdldfBU=
=3hFV
-----END PGP SIGNATURE-----


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-2014 The PostgreSQL Global Development Group