diff options
author | Bruce Momjian <bruce@momjian.us> | 2003-07-31 02:12:43 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2003-07-31 02:12:43 +0000 |
commit | 82bade79dce6ff239cba1491c5843ea8ba2bfcc8 (patch) | |
tree | 7781f7715a4b3dc50c6ae36c26a5b39b27c26762 /src/interfaces/python/tutorial | |
parent | 52347b66370988e55b5b55d78d54ec8f13d1123b (diff) | |
download | postgresql-82bade79dce6ff239cba1491c5843ea8ba2bfcc8.tar.gz postgresql-82bade79dce6ff239cba1491c5843ea8ba2bfcc8.zip |
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
Diffstat (limited to 'src/interfaces/python/tutorial')
0 files changed, 0 insertions, 0 deletions