Re: loading files into tables

Ok

I'm tryint to execute

copy local from "/path" with delimiter "\t";

and I get the following errors

ERROR: must be superuser to COPY to or from a file.

Can I do something similar to it without being superuser?

for a Tab delimiter, should i use "\t" character?

Thanks

Pau

2008/2/4, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>:
>
> Hi,
>
> Le lundi 04 février 2008, Pau Marc Munoz Torres a écrit :
> > I'm an ex-mysql user, i know there was a sentence in mysql that was
> >
> > load data local infile "somefile.txt" into table "sometable;
> >
> > I'm trying to do something similar in postgresql, can someone help me?
>
> COPY manual entry as already been pointed to you, let me introduce
> pgloader
> project in case you would need to edit the data on-the-fly (ETL):
> http://pgloader.projects.postgresql.org/
> http://pgfoundry.org/projects/pgloader/
> http://pgsql.tapoueh.org/site/html/pgloader/index.html
>
> More to come on this last link :)
> --
> dim
>
>

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat