Jim, First of all, thanks for your fast response. I'm doing a
benchmark and your quick turn around will be noted in my findings. I'm trying to use the COPY command. I've tried executing it using
pgadmin and pgsql and receive the same message about no read permissions.
Here is the syntax? COPY as_benchmark.midt FROM 'C:/postgres_data/midt_short.csv' WITH CSV Here is the error I receive. ERROR: could not open file
"c:/postgres_data/midt_short.csv" for reading: Permission denied I understand that postgres must have access, but how do I make sure it
is granted in Windows? Fyi...the use of "/" or "\\" in Windows could use
some documentation explaining the acceptable ways to use them. Thx again, Terry Nolen -----Original Message----- On Wed, Dec 21, 2005 at 04:32:17PM -0600, Nolen, Terry wrote: > I'm new to postgresql and I'm trying to test the copy command with
a csv > file. I keep getting an error which states that I don't have
read > permissions. > > My database is owned by postgres, and I'm signed in as
postgres. The > table that I'm placing the data into has a different owner.
I've tried > changing privileges in windows to allow all access to everyone on
this > machine access. I've even shared the machine with external
users. I've > move the file to different directorys and created a tablespace
with my > new table in it, into the postgres data directory. > > I see this type of error on many boards, but they tend to be with
a > flavor of unix. I'm really not getting the premise behind
what is going > on and why. Could you please assist? We need to know exactly what command you're trying to run, if it's in psql or something else, and the exact error message. -- Jim C. Nasby, Database Architect
[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" |
- [pgadmin-support] COPY permissions problem - Windows XP Nolen, Terry
- Re: [pgadmin-support] COPY permissions problem - Wind... Jim C. Nasby
- Re: [pgadmin-support] COPY permissions problem - Wind... Nolen, Terry
- Re: [pgadmin-support] COPY permissions problem - ... Jim C. Nasby
- Re: [pgadmin-support] COPY permissions proble... john . rylander
- Re: [pgadmin-support] COPY permissions pr... Serge Faucilhon
- Re: [pgadmin-support] COPY permissions proble... john . rylander
- Re: [pgadmin-support] COPY permissions pr... john . rylander
- Re: [pgadmin-support] COPY permissions problem - Wind... Nolen, Terry