From: | momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql-server/contrib/dbase README.dbf2pg dbf2p ... |
Date: | 2003-07-31 02:12:46 |
Message-ID: | 20030731021246.A161DD1C9DC@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian(at)svr1(dot)postgresql(dot)org 03/07/30 23:12:44
Modified files:
contrib/dbase : README.dbf2pg dbf2pg.1 dbf2pg.c
Log message:
dbf2pg - Insert xBase-style .dbf-files into a PostgreSQL-table
There is an option "-s oldname=newname", which changes the old field name of
the dbf-file to the newname in PostgeSQL. If the length of the new name is 0,
the field is skiped. If you want to skip the first field of the dbf-file,
you get the wildest error-messages from the backend.
dbf2pg load the dbf-file via "COPY tablename FROM STDIN". If you skip the
first field, it is an \t to much in STDIN.
A fix could be an counter j=0, which increments only, if a field is imported
(IF (strlen(fields[h].db_name)> 0) j++. And only if j > 1 (if an other field is
imported) the \t is printed.
An other small bug in the README:
-s start
Specify the first record-number in the xBase-file
we will insert.
should be
-e start
Specify the first record-number in the xBase-file
we will insert.
Thomas Behr
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-07-31 04:23:41 | pgsql-server/ oc/TODO rc/bin/psql/common.c |
Previous Message | Tom Lane | 2003-07-30 22:56:25 | pgsql-server/ oc/src/sgml/func.sgml rc/backend ... |