Your current code is caused to fail by the next inputs:
- when the data has null number values.
You can probe it with the examples in:
http://www.clicketyclick.dk/databases/xbase/index.shtml.en
Now I have a new version of dbf2sql with some bug fixed:
- Support MEMO fields.
- Support
ok, It's more difficult to fix the existing version. I don't want to do
a new library. I just use the perl module DBD-XBase rather than rewrite
a library (contrib/dbase/dbf.c). Also, dbf2sql is a perl program... you
can to adapt it to your needs easily.
El mié, 23-03-2005 a las 10:40 -0500,
- It solve problems with numeric columns.
http://archives.postgresql.org/pgsql-novice/2005-01/msg00246.php
http://archives.postgresql.org/pgsql-general/2005-01/msg01382.php
- The output is in SQL.
El mié, 23-03-2005 a las 00:53 -0500, Bruce Momjian escribió:
How is this better than
Manuel Baena García wrote:
El mi?, 23-03-2005 a las 17:07 -0500, Bruce Momjian escribi?:
Are you saying your script has all the functionality of dbf2pg.c? It
doesn't seem possible.
No, I'm not saying it. By example, my script doesn't connect to a pg db,
I prefer to use a pipe. My script
Manuel Baena García wrote:
- It solve problems with numeric columns.
http://archives.postgresql.org/pgsql-novice/2005-01/msg00246.php
http://archives.postgresql.org/pgsql-general/2005-01/msg01382.php
- The output is in SQL.
Uh, can't you just fix the existing version rather than make a new
Manuel Baena García wrote:
ok, It's more difficult to fix the existing version. I don't want to do
a new library. I just use the perl module DBD-XBase rather than rewrite
a library (contrib/dbase/dbf.c). Also, dbf2sql is a perl program... you
can to adapt it to your needs easily.
Are you
How is this better than /contrib/dbase tools?
---
Manuel Baena García wrote:
Hello,
Here is a contrib to translate xBase-style .dbf-files to SQL.
Manuel.
[ Attachment, skipping... ]
[ Attachment, skipping... ]
Hello,
Here is a contrib to translate xBase-style .dbf-files to SQL.
Manuel.
dbf2sql.pl
Description: Perl program
.TH dbf2sql.pl 7 March 2005 dbf2sql.pl 0.4 PostgreSQL contrib
.SH NAME
dbf2sql.pl \- Translate xBase files to SQL statements
.SH SYNOPSIS
.B dbf2sql.pl
.I dbf-file table
.SH