copy command - Mailing list pgsql-general

From Jim Bryan
Subject copy command
Date
Msg-id 20060825222700.80941.qmail@web33505.mail.mud.yahoo.com
Whole thread Raw
Responses Re: copy command  (Gregory Stark <gsstark@mit.edu>)
List pgsql-general
Hi! - Fedora Core 5, cannot copy text file into a
table called datetime, yet the permissions seem OK:

copy datetime from '/home/jb/Desktop/DateTimeData.txt'
with csv;

ERROR:  could not open file
"/home/jb/Desktop/DateTimeData.txt" for reading:
Permission denied

-rw-rw-r-- 1 jb   jb         83 Aug 25 14:30
DateTimeData.txt

Linux log-in is user: jb, su to root for /sbin/service
postgresql start (was installed using default user:
postgres and the servers still use postgres).
This might be more of a linux question, but for some
reason the back-end Postgresql server can't get into
the needed text file -?  Ideas appreciated.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: "Andrzej Folek"
Date:
Subject: mising chunk
Next
From: Jim
Date:
Subject: Can't populate database using Copy