Re: copy import csv problem - Mailing list pgsql-novice

From Joshua b. Jore
Subject Re: copy import csv problem
Date
Msg-id Pine.BSO.4.40.0204150911090.13559-100000@kitten.greentechnologist.org
Whole thread Raw
In response to copy import csv problem  (Peter Lowman <itsasecret4@bigpond.com>)
List 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@postgresql.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-----


pgsql-novice by date:

Previous
From: "cristi"
Date:
Subject: Date format
Next
From: Oliver Elphick
Date:
Subject: Re: Problem in postgresql installation