ERROR: COPY <Table Name> FROM <file>

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: ERROR: COPY <Table Name> FROM <file>
Date: 2004-09-17 18:59:00
Message-ID: 20040917185900.16729.qmail@web61203.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear group,
I am trying to upload a file into a table using COPY
command.

My table:

exp_id exp_X exp_y exp_std exp_npix

My file:
CellHeader=X Y MEAN STDV NPIXELS

My sql statement:
create table EXPERIMENT
(
exp_id serial not null,
exp_name varchar(32) not null,
con_id serial references
contacts(con_id),
exp_type varchar(32) not null,
exp_desc varchar(64),
exp_pmid integer not null,
exp_rawdata_url varchar(32),
constraint experiment_pk primary
key(exp_id)
);

My copy statement:

marray2=> COPY affy_exp from
'/home/speri/temp/postgres/marray2/tm.cel';
ERROR: must be superuser to COPY to or from a file
HINT: Anyone can COPY to stdout or from stdin. psql's
\copy command also works for anyone.
marray2=>

Could any help me whats going wrong with this COPY and
\copy (two different commands).

Thanks

Kumar


_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Todd Kover 2004-09-17 23:06:57 arrays and functions in plpgsql
Previous Message Tom Lane 2004-09-17 18:50:37 Re: Installation problem...