Search Postgresql Archives

Re: loading files into tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Attachment: signature.asc
Description: This is a digitally signed message part.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux