From: Michael Irschick <mirschick@penguinsystems.com>
To: pgsql-interfaces@postgresql.org
Subject: I can not import text file... Errno = Permission denied (13)
Date: Wed, 24 Mar 1999 22:20:25 -0800
Message-ID: <36F9D5A9.5FD3C844@penguinsystems.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mirschick@penguinsystems.com
Subject: Re: I can not import text file... Errno = Permission denied (13)
In-Reply-To: <36F9D5A9.5FD3C844@penguinsystems.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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