Postgres Pro
Downloads
Home   >   mailing lists

Re: loading files into tables - Mailing list pgsql-general

From Pau Marc Munoz Torres
Subject Re: loading files into tables
Date
Msg-id 19b5841a0802040821o362cc043od141cd5782fc715@mail.gmail.com
Whole thread Raw
In response to Re: loading files into tables  (Dimitri Fontaine <dfontaine@hi-media.com>)
Responses Re: loading files into tables  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view
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@hi-media.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.munoz@bioinf.uab.cat

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: [OT] "advanced" database design (long)
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Certification