Can't populate database using Copy

From: Jim <azmode03(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't populate database using Copy
Date: 2006-08-26 18:35:56
Message-ID: 20060826183556.9786.qmail@web37901.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasbinder Bali 2006-08-26 19:32:37 Re: Shared Objects (Dynamic loading)
Previous Message Merlin Moncure 2006-08-26 15:07:33 Re: alternative to using a sequence