pgsql-server/contrib/dbase README.dbf2pg dbf2p ...

Поиск
Список
Период
Сортировка
Искать

pgsql-server/contrib/dbase README.dbf2pg dbf2p ...

От:
momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	momjian@svr1.postgresql.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

FAQ