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] 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.
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 verbosityWho 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, Pennsylvania 19026
On 12/22/2001 12:50:08 AM Bruce Momjian wrote:
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
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 Ivan as 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.
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?
Maarten
----
Maarten Boekhold, maarten.boekhold@reuters.com
Reuters Consulting / TIBCO Finance Technology Inc.
Dubai Media City
Building 1, 5th Floor
PO Box 1426
Dubai, United Arab Emirates
tel:+971(0)4 3918300 ext 249
fax:+971(0)4 3918333
mob:+971(0)505526539
-------------------------------------------------------------- --
Visit our Internet site at http://www.reuters.com
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
Import Notes
Resolved by subject fallback
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 19026Attachments:
/bjm/difftext/plainDownload
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 Ivan as 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, Pennsylvania 19026