Skip site navigation (1) Skip section navigation (2)

Re: COPY permissions problem - Windows XP

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: "Nolen, Terry" <Terry(dot)Nolen(at)sabre(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: COPY permissions problem - Windows XP
Date: 2005-12-22 01:10:08
Message-ID: (view raw or whole thread)
Lists: pgadmin-support
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                decibel(at)decibel(dot)org 
Give your computer some brain candy! 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?"

In response to

pgadmin-support by date

Next:From: Nolen, TerryDate: 2005-12-22 14:53:42
Subject: Re: COPY permissions problem - Windows XP
Previous:From: Nolen, TerryDate: 2005-12-21 22:32:17
Subject: COPY permissions problem - Windows XP

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group