Обсуждение: copying table to a file
Hi, I am attempting to copy the contents of a table to a file, like this: foodserver=> COPY company TO '/home/peter/copytest.out'; But I keep getting this error: ERROR: COPY command, running in backend with effective uid 100, could not open file '/home/peter/copytest.out' for writing. Errno = Permission denied (13). Does anybody know how I can fix this so I have permission to open files? Thanks, Tyler Wood twood@uwm.edu
Tyler Robert Wood wrote: > > Hi, > I am attempting to copy the contents of a table to a file, like this: > > foodserver=> COPY company TO '/home/peter/copytest.out'; > > But I keep getting this error: > > ERROR: COPY command, running in backend with effective uid 100, could not > open file '/home/peter/copytest.out' for writing. Errno = Permission > denied (13). Use \copy in psql or do it yourself from within a program. COPY tells the database server to copy the data, which may not even be on the same machine... > Does anybody know how I can fix this so I have permission to open files? It's using the backend permissions, which probably can't write anywhere. Use \copy and be happy... -- Martijn van Oosterhout <kleptog@cupid.suninternet.com> http://cupid.suninternet.com/~kleptog/
On Fri, 16 Jun 2000 (Yesterday), Tyler Robert Wood wrote: TRW> TRW> Hi, TRW> I am attempting to copy the contents of a table to a file, like this: TRW> TRW> foodserver=> COPY company TO '/home/peter/copytest.out'; TRW> TRW> TRW> But I keep getting this error: TRW> TRW> ERROR: COPY command, running in backend with effective uid 100, could not TRW> open file '/home/peter/copytest.out' for writing. Errno = Permission TRW> denied (13). TRW> TRW> Does anybody know how I can fix this so I have permission to open files? Make allow access to '/home/peter' for user #100 Or better make in your home something like: $ cd /home/peter $ mkdir sql $ chmod 777 sql and after this make foodserver=> COPY company TO '/home/peter/sql/copytest.out'; Attn: You can have "superuser" permission for work with files from sql! Method #2: $ psql foodserver -c "COPY company TO stdout" -o /home/peter/copytest.out This method don't need "superuser" permission... -- Trurl McByte, Capt. of StasisCruiser "Prince" |InterNIC: AR3200 RIPE: AR1627-RIPE| |--98 C3 78 8E 90 E3 01 35 87 1F 3F EF FD 6D 84 B3--|