Thread: copy import csv problem

copy import csv problem

From
Peter Lowman
Date:
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


Re: copy import csv problem

From
"Joshua b. Jore"
Date:
-----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-----