Re: COPY command error in psql.

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Matthew Stanfield <matthew(at)propertyknowledge(dot)com>
Cc: PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY command error in psql.
Date: 2002-04-09 13:51:21
Message-ID: 20020409235121.D7955@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 09, 2002 at 02:39:22PM +0100, Matthew Stanfield wrote:
> Hi,
>
> I'm trying to import tables in psql but am getting a permission denied
> error. I'm using the '\i file' command as I intend to import 100+ tables
> and want to set this up to run overnight (almost 1 GB of data is going in).
>
> My test for this is not working. I have a 'batch' file the contents of
> which are (at the moment) only:
>
> COPY ab FROM '/home/ms/db/csv/AB.csv'
>
> Table 'ab' exists as does the csv file and I am logged in as 'postgres'.

You want \copy. COPY asks the backend to do it, which may not have
permission, as you noticed.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Ignorance continues to thrive when intelligent people choose to do
> nothing. Speaking out against censorship and ignorance is the imperative
> of all intelligent people.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lee Kindness 2002-04-09 13:51:45 COPY command error in psql.
Previous Message Tom Lane 2002-04-09 13:50:43 Re: COPY command error in psql.