Thread: usage of copy command in pgsql

usage of copy command in pgsql

From
rama krishna
Date:
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

Re: usage of copy command in pgsql

From
Martijn van Oosterhout
Date:
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

Re: usage of copy command in pgsql

From
"A. Kretschmer"
Date:
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    ===