Skip to main content.

PX2SQLITE

Name

px2sqlite -- Read Paradox file and dump the records into sqlite database

Synopsis

px2sqlite [-h | --help ] [-i | --info ] [-o FILE | --output-file=FILE ] [-n FILE | --primary-index-file=FILE ] [-r ENCODING | --recode=ENCODING ] [--tablename=NAME ] [--delete-tablename ] [--skip-schema ] [--set-sql-type=SPEC ] [--empty-string-is-null ] [FILE ]

DESCRIPTION

This manual page documents the px2sqlite command.

px2sqlite reads Paradox files and dumps each record into a sqlite database. The sqlite database will be created if it does not exists. If the table already exists it will only be deleted if the option --delete-table is passed. The option -o is required because the output cannot be written to stdout. px2sqlite is equivalent to pxview(1) when called with the option -q.

OPTIONS

The program follows the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below.

For a detailed description of all options see the man page of pxview(1).

SEE ALSO

pxview(1), pxwrite(1), recode(1), iconv(1)

AUTHOR

This manual page was written by Uwe Steinmann <>. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover Texts.

Latest News

Released version 0.2.5

August 9, 2005

  • output some more information about blobs in debug mode
  • Output password checksum if file is encrypted
  • output format of timestamp, date, time can be set with program option. The default has been changed to the sql format.

New web site

02 Feb 05

After a long time the web site has been overhauled with much more information about pxview.

Released version 0.2.4

January 24, 2005

  • check return value of PX_get_data_alpha() and output an error message if needed
  • mask special chars in memoblobs (sql output)
  • use delimeter char for fields if they contain a line break (csv output)
  • surrounds field data of memoblobs by enclosure char (csv output)
  • primary key fields are treated as unique(field1, field2, field3, ...) and not unique(field1), unique(field2), ...
  • fixed various memory leaks
  • fixed many compiler warnings
  • configure checks for PX_timestamp2string() to ensure pxlib >= 0.4.3 is present
  • use functions like PX_get_num_fields() and PX_get_value() instead of directly accessing the file header structure
  • create html version of manual pages on request

More News »