copy command

From: Jim Bryan <gooddayarizona(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: copy command
Date: 2006-08-25 22:27:00
Message-ID: 20060825222700.80941.qmail@web33505.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Silvela, Jaime (Exchange) 2006-08-25 22:34:54 speeding up big query lookup
Previous Message Jeff Davis 2006-08-25 22:04:27 Re: Saving a jpg into Postgresql table