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 <[EMAIL PROTECTED]>:
>
> 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 : [EMAIL PROTECTED]
