Re: ERROR: COPY <Table Name> FROM <file>

From: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
To: Kumar S <ps_postgres(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: COPY <Table Name> FROM <file>
Date: 2004-09-18 12:44:20
Message-ID: a06110400bd71dda53bf0@[192.168.0.243]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

>marray2=> COPY affy_exp from
>'/home/speri/temp/postgres/marray2/tm.cel';
>ERROR: must be superuser to COPY to or from a file

This means you must log in to pgsql with enough privileges, e.g. as
the user 'postgres'

Marc

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Neacal 2004-09-18 15:32:53 Importing data into postgreSQL from FileMaker?
Previous Message Tom Lane 2004-09-18 01:41:13 Re: arrays and functions in plpgsql