Thread: contrib/dbase
I just looked at the source for dbase. I have a long hacked version of this. The one in contrib is based on a newer version of what I have been using. It is funny, because I made some of the same changes to mine as are in the one in contrib, with a few exceptions. usage: dbf2pg [options] filename.dbf Options -h hostname, host name of PostgreSQL server -y translate field name, oldname=newname -z translate data type, fieldname=datatype -d dbase -t table_name -p prefix, prepends prefix to default table name [-c | -D] Createor delete -f convert field names to lower case [-u | -l] Converts data to upper or lowercase, respectively -v[v] sets verbosity Who contributed it? Did Maarten Boekhold? I would like to merge my data type and table prefix code into the main tree, if this is where it will now be officially maintained.
> I just looked at the source for dbase. I have a long hacked version of > this. The one in contrib is based on a newer version of what I have been > using. > > It is funny, because I made some of the same changes to mine as are in > the one in contrib, with a few exceptions. > > usage: dbf2pg [options] filename.dbf > Options > -h hostname, host name of PostgreSQL server > -y translate field name, oldname=newname > -z translate data type, fieldname=datatype > -d dbase > -t table_name > -p prefix, prepends prefix to default table name > [-c | -D] Create or delete > -f convert field names to lower case > [-u | -l] Converts data to upper or lower case, > respectively > -v[v] sets verbosity > > > Who contributed it? Did Maarten Boekhold? I would like to merge my data > type and table prefix code into the main tree, if this is where it will > now be officially maintained. contrib/README shows: dbase - Converts from dbase/xbase to PostgreSQL by Ivan Baldo, lubaldo@adinet.com.uy Yes, please send in your improvements and we will add them. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
<br /><font face="sans-serif" size="2">On 12/22/2001 12:50:08 AM Bruce Momjian wrote:<br /> > > Who contributed it?Did Maarten Boekhold? I would like to merge my data<br /> > > type and table prefix code into the main tree, ifthis is where it will<br /> > > now be officially maintained.<br /> > <br /> > contrib/README shows:<br />> <br /> > dbase -<br /> > Converts from dbase/xbase to PostgreSQL<br /> > by Ivan Baldo, lubaldo@adinet.com.uy<br /></font><br /><font face="sans-serif" size="2">Hmmm, this was most certainlyoriginally written by me, with (according to the README) later updates from </font><font face="Courier New" size="3">FrankKoormann (</font><a href="mailto:fkoorman@usf.uni-osnabrueck.de"><font color="blue" face="Courier New" size="3"><u>fkoorman@usf.uni-osnabrueck.de</u></font></a><fontface="Courier New" size="3">)</font><font face="sans-serif"size="2"> (dbf.c). Not to be picky, but listing Ivan as the (only) author doesn't sound right to me. Someof the files have funny CVS history entries, i.e. references to WAL locking code?!?</font><br /><br /><font face="sans-serif"size="2">I've also got a version on my own systems that *appears* to be newer, supposedly with bug fixesand added features. I'll have to verify that though.</font><br /><br /><font face="sans-serif" size="2">btw. there'sa listing of my email address in dbf.h that doesn't exist anymore. Can somebody update it to read maarten.boekhold@reuters.com?</font><br/><br /><font face="sans-serif" size="2">Maarten</font><br /><font face="sans-serif"size="2"><br /> ----<br /><br /> Maarten Boekhold, maarten.boekhold@reuters.com<br /><br /> Reuters Consulting/ TIBCO Finance Technology Inc.<br /> Dubai Media City<br /> Building 1, 5th Floor<br /> PO Box 1426<br /> Dubai,United Arab Emirates<br /> tel:+971(0)4 3918300 ext 249<br /> fax:+971(0)4 3918333<br /> mob:+971(0)505526539</font><code><fontsize="3"><br /><br /> ----------------------------------------------------------------<br /> Visit our Internet site at http://www.reuters.com<br/><br /> Any views expressed in this message are those of the individual<br /> sender, except wherethe sender specifically states them to be<br /> the views of Reuters Ltd.<br /></font></code>
> btw. there's a listing of my email address in dbf.h that doesn't exist > anymore. Can somebody update it to read maarten.boekhold@reuters.com? OK, updated. I found your email in two other files. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 Index: contrib/README =================================================================== RCS file: /cvsroot/pgsql/contrib/README,v retrieving revision 1.50 diff -c -r1.50 README *** contrib/README 2001/10/12 23:19:09 1.50 --- contrib/README 2001/12/31 13:30:22 *************** *** 44,50 **** dbase - Converts from dbase/xbase to PostgreSQL ! by Ivan Baldo, lubaldo@adinet.com.uy dblink - Allows remote query execution --- 44,52 ---- dbase - Converts from dbase/xbase to PostgreSQL ! by Maarten.Boekhold <Maarten.Boekhold@reuters.com>, ! Frank Koormann <fkoorman@usf.uni-osnabrueck.de>, ! Ivan Baldo <lubaldo@adinet.com.uy> dblink - Allows remote query execution Index: contrib/dbase/dbf.h =================================================================== RCS file: /cvsroot/pgsql/contrib/dbase/dbf.h,v retrieving revision 1.4 diff -c -r1.4 dbf.h *** contrib/dbase/dbf.h 2001/11/05 17:46:22 1.4 --- contrib/dbase/dbf.h 2001/12/31 13:30:22 *************** *** 2,8 **** declares routines for reading and writing xBase-files (.dbf), and associated structures ! Maarten Boekhold (boekhold@cindy.et.tudelft.nl) 29 oktober 1995 */ #ifndef _DBF_H --- 2,8 ---- declares routines for reading and writing xBase-files (.dbf), and associated structures ! Maarten Boekhold (maarten.boekhold@reuters.com) 29 oktober 1995 */ #ifndef _DBF_H Index: contrib/dbase/dbf2pg.c =================================================================== RCS file: /cvsroot/pgsql/contrib/dbase/dbf2pg.c,v retrieving revision 1.7 diff -c -r1.7 dbf2pg.c *** contrib/dbase/dbf2pg.c 2001/12/30 23:09:41 1.7 --- contrib/dbase/dbf2pg.c 2001/12/31 13:30:23 *************** *** 1,7 **** /* This program reads in an xbase-dbf file and sends 'inserts' to an PostgreSQL-server with the records in the xbase-file ! M. Boekhold (boekhold@cindy.et.tudelft.nl) okt. 1995 oktober 1996: merged sources of dbf2msql.c and dbf2pg.c oktober 1997: removed msql support */ --- 1,7 ---- /* This program reads in an xbase-dbf file and sends 'inserts' to an PostgreSQL-server with the records in the xbase-file ! M. Boekhold (maarten.boekhold@reuters.com) okt. 1995 oktober 1996: merged sources of dbf2msql.c and dbf2pg.c oktober 1997: removed msql support */ Index: contrib/dbase/endian.c =================================================================== RCS file: /cvsroot/pgsql/contrib/dbase/endian.c,v retrieving revision 1.2 diff -c -r1.2 endian.c *** contrib/dbase/endian.c 2001/10/25 05:49:19 1.2 --- contrib/dbase/endian.c 2001/12/31 13:30:23 *************** *** 1,4 **** ! /* Maarten Boekhold (boekhold@cindy.et.tudelft.nl) oktober 1995 */ #include <sys/types.h> #include "dbf.h" --- 1,4 ---- ! /* Maarten Boekhold (maarten.boekhold@reuters.com) oktober 1995 */ #include <sys/types.h> #include "dbf.h"
> Hmmm, this was most certainly originally written by me, with (according to > the README) later updates from Frank Koormann (fkoorman@usf.uni-osnabrueck.de) (dbf.c). Not to be picky, but listing Ivanas the (only) author doesn't > sound right to me. Some of the files have funny CVS history entries, i.e. > references to WAL locking code?!? > > I've also got a version on my own systems that *appears* to be newer, > supposedly with bug fixes and added features. I'll have to verify that > though. Please send over some improvements if you have them. Thanks. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026