Exporting Postgres DB to SQLite DB

This is a step-by-step procedure for exporting all tables and data from a Postgres database to a new SQLite database:

This procedure assumes that there is a fully populated Postgres database running on a specific port and that you are logged into the server as a user that has "supper user" permissions to the Postgres database.

Examples used in this procedure are for a Postgres database running on gauss and that the SQLite database will be created on gauss.