| From: | Michael Irschick <mirschick(at)penguinsystems(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | I can not import text file... Errno = Permission denied (13) |
| Date: | 1999-03-25 06:20:25 |
| Message-ID: | 36F9D5A9.5FD3C844@penguinsystems.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
I have not been able to insert a text file into my postgres table.
Here is the file.
-rw-rw-r-- 1 mirschic mirschic 14 Mar 24 21:26 test.txt
/home/mirschick/test.txt
"test","test"
----
oprs=> copy entmap from '/home/mirschick/test.txt' using delimiters ',';
ERROR: COPY command, running in backend with effective uid 100, could
not open file '/home/mirschick/test.txt' for reading. Errno =
Permission denied (13).
oprs=>
---
So what is going on? I tried diff text files, and diff tables I always
get the same error. (Errno = Permission denied)
my username is mirschick
I created the text file as mirschick
I created the table, and database as mirschick.
---
Thanks for any help.. I am a newbie....
mirschick(at)penguinsystems(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | MAILER-DAEMON | 1999-03-25 06:39:31 | Undeliverable Message |
| Previous Message | MAILER-DAEMON | 1999-03-25 06:16:08 | Undeliverable Message |