Read the COPY manual page. Permissions for COPY are based on the server user, not the psql user. Try psql \copy.
--------------------------------------------------------------------------- Nahum Castro wrote: > > The following bug has been logged online: > > Bug reference: 2298 > Logged by: Nahum Castro > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.1 > Operating system: Linux Kernel 2.6.22 > Description: Bug using copy > Details: > > When I try to copy from a file using psql I get the permision error, so I > can not load from any file > [EMAIL PROTECTED] datos]$ ls -l > total 96 > -rwxrwxr-x 1 geografia geografia 30189 mar 2 12:52 archivo1.csv > -rwxrwxrwx 1 geografia geografia 30189 mar 2 12:43 archivo.csv > -rw-rw-r-- 1 geografia geografia 30189 mar 2 13:32 ar.csv > [EMAIL PROTECTED] datos]$ pwd > /home/geografia/datos > [EMAIL PROTECTED] datos]$ psql geoest > Bienvenido a psql 8.1.1, la terminal interactiva de PostgreSQL. > > Digite: \copyright para ver los t??rminos de distribuci??n > \h para ayuda de comandos SQL > \? para ayuda de comandos psql > \g o or termine con punto y coma para ejecutar una consulta > \q para salir > > geoest=# copy datos2 (dato_float, cve_subtema, fecha, fuente, cve_mpio) from > '/home/geografia/datos/ar.csv' with csv; > ERROR: no se pudo abrir archivo ??/home/geografia/datos/ar.csv?? para > lectura: Permiso denegado > geoest=# > > But it works if I copy the file to /opt/ and load from there. > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
