The jinaga-export-postgres
command-line tool allows you to export data from a Jinaga PostgreSQL database.
This package can be used directly via npx
without installation, or you can install it globally using npm:
npm install -g jinaga-export-postgres
To use the tool, run the following command:
npx jinaga-export-postgres --host <host> --port <port> --database <database> --user <user> --password <password> --format <format>
Replace the placeholders with your PostgreSQL database details:
<host>
: The hostname of your PostgreSQL server<port>
: The port number of your PostgreSQL server<database>
: The name of your Jinaga database<user>
: The username for accessing the database<password>
: The password for the specified user<format>
: The output format. Must be either 'json' or 'factual'Example:
npx jinaga-export-postgres --host localhost --port 5432 --database myjinagarecords --user myuser --password mypassword --format json
The tool will connect to the specified PostgreSQL database, check for the existence of the 'fact' table, and if it exists, export all facts from the table in the specified format.
To save the output to a file, you can use output redirection:
For JSON format:
npx jinaga-export-postgres --host localhost --port 5432 --database mydb --user myuser --password mypassword --format json > output.json
For Factual format:
npx jinaga-export-postgres --host localhost --port 5432 --database mydb --user myuser --password mypassword --format factual > output.fact