Thread: bulk loader
Hi All, 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)!!!! Thanks, Hrishi
Hrishikesh Deshmukh wrote: > Hi All, > > 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)!!!! See the COPY command. Tab is the default delimiter in text mode. -- Guy Rouillier
Hrishikesh Deshmukh <hdeshmuk@gmail.com> writes: > Hi All, > > 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)!!!! Read up on the COPY command. -Doug
After takin a swig o' Arrakan spice grog, hdeshmuk@gmail.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.
On Thu, 19 May 2005, Hrishikesh Deshmukh wrote: > Hi All, > > 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)!!!! See copy from memory, pretty much as in: cat <file> | \ psql -d $DB -c "copy <table> from STDIN [with delimiter ','];" You'll see that db users can't copy a file into a table but can copy STDIN, so this approach works well. Brent Wood