pgsql2sqlite1
Postgresql/postgis to sqlite3 converter
Usage
pgsql2sqlite [options]
Overview
pgsql2sqlite is a program that converts data from a PostGIS database to SQLite.
Options
-
-?, --help -
Show summary of options.
-
-h, --host -
Allows you to specify connection to a database on a machine other than the default.
-
-p, --port -
Allows you to specify a database port other than the default.
-
-d, --dbname -
PostgreSQL database name
-
-u, --user -
Connect to the database as the specified user.
-
-P, --password -
Connect to the database with the specified password.
-
-q, --query -
Name of the table/or query to pass to postmaster
-
-t, --table -
Name of the output table to create (default: table in query)
-
-f, --file -
Use this option to specify the name of the file to create.