From: | Christopher Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: bulk loader |
Date: | 2005-05-20 03:54:27 |
Message-ID: | m34qcypn64.fsf@knuth.cbbrowne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
After takin a swig o' Arrakan spice grog, hdeshmuk(at)gmail(dot)com (Hrishikesh Deshmukh) belched out:
> Is there a "bulk loader" in postgresql with which one can read in say
> a tab delimited format text file. Before one does all one has to do is
> create the table with text file column names as attributes, once it is
> on DBMS world it will be a simple table (non-relational)!!!!
There is the built in "COPY" command which can do this sort of thing.
Jan Wieck wrote a "load" tool that does a more sophisticated job of
slicing up the data. Look at pgFoundry.org for "pgloader". There are
thoughts of trying to make this work much like Oracle's SQL*Loader
product.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com').
http://linuxdatabases.info/info/postgresql.html
FLORIDA: We've been Gored by the bull of politics and we're Bushed.
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2005-05-20 03:57:37 | Re: Postgres in government |
Previous Message | OpenMacNews | 2005-05-20 03:42:35 | Re: 8.0.3 build error on Mac OS X 10.4 |