A C++ tool to dump a PostgreSQL database to SQLite3
This tool allows to dump a full / parts of a PostgreSQL database into an SQLite3 database.
It can handle PostgreSQL large objects (converted to blobs) and applies special semantics to special data types (such as dates, e.g. converting infinity::timestamp into 9999-12-31 12:00:00) for maximum compatibility.
Furthermore, autoincrement columns are converted into an UPDATE trigger, indices are recreated and the final database is ANALYZEd for maximum performance.
It makes use of the OptionParser to simplify argument parsing and config file handling.