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

copy import csv problem

From: Peter Lowman <itsasecret4(at)bigpond(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: copy import csv problem
Date: 2002-04-13 22:52:42
Message-ID: 3CB8B6BA.6030605@bigpond.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


Responses

pgsql-novice by date

Next:From: Peter LowmanDate: 2002-04-13 23:05:35
Subject: copy import csv problem
Previous:From: Christian UbbesenDate: 2002-04-13 16:57:50
Subject: Returning recordset from sp

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