Thread: usage of copy command in pgsql
I have to copy the file to a table data base
the command used for this is COPY
But it showing the error like no permission is granted to read the file.
for this i gave 777 permissions to that file even the same err repeated.
What to do for this
On Thu, Feb 16, 2006 at 05:13:22PM +0530, rama krishna wrote: > I have to copy the file to a table data base > the command used for this is COPY > But it showing the error like no permission is granted to > read the file. > for this i gave 777 permissions to that file even the same err repeated. > What to do for this You don't say which OS or version of postgres. However, COPY from arbitrary file is limited to superusers and even then, it must be readable to the backend (including all parent directories. Perhaps what you're looking for is \copy which work for clients and doesn't require special permissions. -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment
am 16.02.2006, um 17:13:22 +0530 mailte rama krishna folgendes: > I have to copy the file to a table data base > the command used for this is COPY > But it showing the error like no permission is granted to > read the file. > for this i gave 777 permissions to that file even the same err repeated. > What to do for this You, particularly postgres, need read access for the whole path to this file. HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===