COPY permissions problem - Windows XP - Mailing list pgadmin-support

<p align="LEFT"><span lang="en-us"><font face="Arial" size="2">I</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Arial" size="2">’</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
size="2">mnew to postgresql and I</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
size="2">’</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">m trying to test the
copycommand with a csv file.  I keep getting an error which states that I don</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">’</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Arial" size="2">t have read permissions.</font></span><p align="LEFT"><span lang="en-us"><font
face="Arial"size="2">My database is owned by postgres, and I</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Arial" size="2">’</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
size="2">msigned in as postgres.  The table that I</font></span><span lang="en-us"></span><span lang="en-us"><font
face="Arial"size="2">’</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial" size="2">m placing
thedata into has a different owner. </font></span><span lang="en-us"></span><span lang="en-us"> <font face="Arial"
size="2">I</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">’</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">ve tried changing privileges in windows to allow all
accessto everyone on this machine access.  I</font></span><span lang="en-us"></span><span lang="en-us"><font
face="Arial"size="2">’</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial" size="2">ve even
sharedthe machine with external users.  I</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
size="2">’</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">ve move the file to
differentdirectorys and created a tablespace</font></span><span lang="en-us"></span><span lang="en-us"> <font
face="Arial"size="2">with my new table in it,</font></span><span lang="en-us"></span><span lang="en-us"> <font
face="Arial"size="2">in</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
size="2">to</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2"> the postgres data
directory</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">.</font></span><p
align="LEFT"><spanlang="en-us"><font face="Arial" size="2">I see this type of error on many boards, but they tend to be
witha flavor of unix</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
size="2">. </font></span><spanlang="en-us"></span><span lang="en-us"> <font face="Arial" size="2">I</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">’</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Arial" size="2">m really not getting the premise behind</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Arial" size="2">what is going on and why.</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Arial" size="2"></font></span><span lang="en-us"></span><span
lang="en-us"> <fontface="Arial" size="2"> C</font></span><span lang="en-us"></span><span lang="en-us"><font
face="Arial"size="2">ould you please assist</font></span><span lang="en-us"></span><span lang="en-us"><font
face="Arial"size="2">?</font></span><span lang="en-us"></span><span lang="en-us"></span><p align="LEFT"><span
lang="en-us"><fontface="Arial" size="2">Terry Nolen</font></span><p align="LEFT"><span lang="en-us"><font face="Arial"
size="2">SabreAirline Solutions</font></span><p align="LEFT"><span lang="en-us"><font face="Arial"
size="2">682-605-1173</font></span><spanlang="en-us"></span><span lang="en-us"></span>