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
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... |