Skip to main content.

PX2SQL

Name

px2sql -- Read Paradox file and dump the records in sql format

Synopsis

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

DESCRIPTION

This manual page documents the px2sql command.

px2sql reads Paradox files and dumps each record in sql format. The resulting file will contain all sql statements to delete an existing table (only if --delete-table is passed), create a new table, create all indexes, and insert all records. px2sql is equivalent to pxview(1) when called with the option -s.

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 »