Skip site navigation (1) Skip section navigation (2)

problem with COPY command

From: Alain Hermosilla Ringger <ahermosi(at)lonquensur(dot)cl>
To: pgsql-novice(at)postgresql(dot)org
Subject: problem with COPY command
Date: 2003-11-16 23:30:51
Message-ID: 3FB808AB.3010906@lonquensur.cl (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-novice
I have a problem to populate a database with the copy command

my write command are:

> COPY telefono FROM '/home/alain/Documents/prueba2.txt'
>  WITH DELIMITER AS ',';

The pgsql server answer the following:

> ERROR:  COPY command, running in backend with effective uid 26, could 
> not open file '/home/alain/Documents/prueba2.txt' for reading.  Errno 
> = Permiso denegado (13).


Thank you for your atention

Alain Hermosilla
ahermosi(at)lonquensur(dot)cl






Responses

pgsql-novice by date

Next:From: Daniel StaalDate: 2003-11-16 23:50:17
Subject: Re: how to send scheduled email from PostgreSQL
Previous:From: Andre DubucDate: 2003-11-16 19:48:47
Subject: Re: Postmaster refuses to start

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group