aboutsummaryrefslogtreecommitdiff
path: root/src/interfaces/python/tutorial
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2003-07-31 02:12:43 +0000
committerBruce Momjian <bruce@momjian.us>2003-07-31 02:12:43 +0000
commit82bade79dce6ff239cba1491c5843ea8ba2bfcc8 (patch)
tree7781f7715a4b3dc50c6ae36c26a5b39b27c26762 /src/interfaces/python/tutorial
parent52347b66370988e55b5b55d78d54ec8f13d1123b (diff)
downloadpostgresql-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