pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
I can not import text file...  Errno = Permission denied (13)
2+ messages / 1 participants
[nested] [flat]

* I can not import text file...  Errno = Permission denied (13)
@ 1999-03-25 06:01  Michael Irschick <mirschick@penguinsystems.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Irschick @ 1999-03-25 06:01 UTC (permalink / raw)
  To: 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@penguinsystems.com




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* I can not import text file... Errno = Permission denied (13)
@ 1999-03-25 06:20  Michael Irschick <mirschick@penguinsystems.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Irschick @ 1999-03-25 06:20 UTC (permalink / raw)
  To: 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@penguinsystems.com






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-03-25 06:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-25 06:01 I can not import text file...  Errno = Permission denied (13) Michael Irschick <mirschick@penguinsystems.com>
1999-03-25 06:20 I can not import text file... Errno = Permission denied (13) Michael Irschick <mirschick@penguinsystems.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox