Re: COPY question

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Szymon Guz <mabewlun(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY question
Date: 2010-10-22 04:36:01
Message-ID: 4CC114B1.50201@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/22/2010 05:16 AM, Szymon Guz wrote:
> Hi,
> I still get the same error while using COPY FROM 'file'. I have to pass
> the full directory for this to work, example:

Sounds like you want to be using psql's \copy, not the server side COPY.
\copy is aware of your current working directory and doesn't require the
server to have permission to access the file - or even be on the same
machine.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-10-22 07:28:33 Re: compile error in libpq program
Previous Message John R Pierce 2010-10-22 01:07:10 Re: compile error in libpq program