Re: [GENERAL] dbase converter
Thanks to all who responded! As you mentioned Xbase really makes life easy
cf.http://www.startech.keller.tx.us/xbase/xbase.html
Knocked something together using it, and it looks uncannily like pg2xbase,
though the latter seems to need some fixing eg Pointer_to_Mem could be
initialised to prevent a spurious character followed by comma in
INSERT ( ���,fieldname1,fieldname2)
Thanks again,
Patrick
Oleg Broytmann wrote on 21 Feb 1999:
Hello!
Just found on FreshMeat:
http://w3.man.torun.pl/~makler/prog/pg2xbase.html
Tool to convert Postgres to/from DBF files (required C++ and libxbase
C++ library).
Distribution license: GPL
Oleg Broytmann wrote on 8 Apr 1999:
On Thu, 8 Apr 1999, Patrick Welche wrote:
Is there a dbase3 <=> postgresql converter available at all? I found
dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as-p primary:
Select the primary key. You have to give the exact
field-name. (Only for dbf2msql, Postgres95 doesn't have a primary key)which of course PostgreSQL does. Anyone know of something more recent?
I heared about some project called "xbase". Try to search FreshMeat for
"xbase", "dbf postgres" or such...
Remigiusz Sokolowski wrote on 9 Apr 1999:
http://w3.man.torun.pl/~makler/prog/pg2xbase.html
this address is worth of checking - as I see - there are here utilities
for convertion from and to postgres.
Hope this helps
Rem
Jim Mercer wrote on 8 Apr 1999:
Show quoted text
i used the dbf2sql library to create a utility to dump dbf file into two
ascii text files.one file generated is an sql create statement and the other is a series of
sql insert statements, "insert into table (attr, attr) values (val, val);"for me, it was easy enough to modify the test files to my tastes with
external scripts or manual editting, than to rework the code to do actual
inserts.feel free to have a look:
ftp://ftp.reptiles.org/pub/pgsql/dbf2sql-2.0-rep.tar.gz
this is the dbf2sql-2.0 stuff, plus the source for my program (mydb).
the makefile is minimally modified to my tastes.
Import Notes
Reply to msg id not found: Pine.SOL2.3.96.SK.990408195826.3496R-100000@sun.med.ru
Subject: Re: [GENERAL] dbase converter
Is there a dbase3 <=> postgresql converter available at all? I found
dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as-p primary:
Select the primary key. You have to give the exact
field-name. (Only for dbf2msql, Postgres95 doesn't have a primary key)which of course PostgreSQL does. Anyone know of something more recent?
I heared about some project called "xbase". Try to search FreshMeat for
"xbase", "dbf postgres" or such...
dBase III+ & IV have two commands (COPY TO filename TYPE filetype &
APPEND FROM ) which allow you import & export a table as a
comma-delimited (or a specified delimiter) ASCII text file
....Postgresql allows you to COPY TO/FROM xxxx USING DELIMITER 'y' a
text file....of course both tables will have to have the same
structure.... this isn't as tedious as it sounds once you do a few
dbase <=> postgres exchanges...
....Bill Sneed, Prospect, Maine....
Import Notes
Reference msg id not found: 199904100300.XAA26771@hub.org | Resolved by subject fallback
Thanks to all who helped with the SERIAL function. Upgrading to PG-6.4.2
solved the problem.
I am now looking for something that converts an access database to a
PostgreSQL database. Does anyone know of such an animal?
Never retreat. Never surrender. Never cut a deal with a dragon.
_______________________________________________________________
Justin Long CIO / Site Editor
616 Station Square Ct Network for Strategic Missions
Chesapeake, VA 23320 977 Centerville Trnpk CSB 317
JustinLong@xc.org Va Beach, VA 23463
Check out our site at: http://www.strategicnetwork.org
How do you st linux to keep sulogs. I know solaris does it in
/var/adm/sulog but in linux it says you can compile it into su. Has anyone
sone that
==========================================================================
_____________
|_|_|_|_|_|_|_| Thorsten Hofrichter
|_| Georgia College CBX 2883
|_| Milledgeville, GA 31061
|_| SYSTEM ADMINISTRATOR
|_| E-Mail : thholr@alef.gcsu.edu
|_| ... WEB Page Address: http://alef.gcsu.edu:80/~thholr
==========================================================================
It is logged in the regular log file (/var/log/messages).
HTH
Rick
==========================================================
On Mon, 12 Apr 1999, Thorsten Hofrichter wrote:
Show quoted text
How do you st linux to keep sulogs. I know solaris does it in
/var/adm/sulog but in linux it says you can compile it into su. Has anyone
sone that==========================================================================
_____________
|_|_|_|_|_|_|_| Thorsten Hofrichter
|_| Georgia College CBX 2883
|_| Milledgeville, GA 31061
|_| SYSTEM ADMINISTRATOR
|_| E-Mail : thholr@alef.gcsu.edu
|_| ... WEB Page Address: http://alef.gcsu.edu:80/~thholr
==========================================================================