Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: copying table to a file
- From: Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
- To: Tyler Robert Wood <twood(at)csd(dot)uwm(dot)edu>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: copying table to a file
- Date: Sun, 18 Jun 2000 00:40:11 +1000
- Message-id: <394B8DCB.4C8E1047@cupid.suninternet.com> <text/plain>
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(at)cupid(dot)suninternet(dot)com> http://cupid.suninternet.com/~kleptog/
- References:
- copying table to a file
- From: Tyler Robert Wood
- copying table to a file
- Prev by Date: Re: [Fwd: SQL3 recursive unions]
- Next by Date: Select data from multiple databases
- Previous by thread: copying table to a file
- Next by thread: Re: copying table to a file
- Indexes: