Can't populate database using Copy

Поиск
Список
Период
Сортировка
От Jim
Тема Can't populate database using Copy
Дата
Msg-id 20060826183556.9786.qmail@web37901.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Can't populate database using Copy  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
copy tabledaily from '/home/jb/FinalData.txt' with csv;
ERROR:  could not open file "/home/jb/FinalData.txt" for reading: Permission denied.  Yet everything else works, including populating tables with Insert queries.

All the permissions were changed for world access ( perhaps bad idea but out of  frustration; and am the only person on this computer ).
drwxrwxrwx   3 root root  4096 Aug 21 10:19 home
drwxrwxrwx 25 jb jb 4096 Aug 26 11:18 jb
-rwxrwxrwx 1 jb   jb     255 Aug 25 18:15 FinalData.txt

I see other people with this same problem on the mailing lists, but no example-solutions are offered.  Can you get the newbys started ?  Thanks.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jim Bryan
Дата:
Сообщение: copy command
Следующее
От: snacktime
Дата:
Сообщение: implementing a read lock