copy command

Поиск
Список
Период
Сортировка
От Jim Bryan
Тема copy command
Дата
Msg-id 20060825222700.80941.qmail@web33505.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: copy command  (Gregory Stark <gsstark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Andrzej Folek"
Дата:
Сообщение: mising chunk
Следующее
От: Jim
Дата:
Сообщение: Can't populate database using Copy