Thread: ERROR: COPY <Table Name> FROM <file> : Postgres Professional

Thread: ERROR: COPY FROM

ERROR: COPY

From

Kumar S

Date:

18 September 2004, 06:29:29

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

Re: ERROR: COPY

FROM

From

"M. Bastin"

Date:

18 September 2004, 16:44:33

>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