Re: COPY ... FROM Permission denied ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY ... FROM Permission denied ...
Date: 2009-01-06 19:12:22
Message-ID: 9771.1231269142@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> writes:
> All I'm getting is a Permission denied upon issuing the COPY command from
> within psql interactive terminal!

Since you didn't show what you did or what the error was, we're just
guessing ... but I'm going to guess that you should use \copy not COPY.
The server normally can't read files in your home directory.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pedro Doria Meunier 2009-01-06 19:18:07 Re: COPY ... FROM Permission denied ...
Previous Message Scott Marlowe 2009-01-06 18:48:47 Re: COPY ... FROM Permission denied ...