PostgresSQL

PostgreSQL is a powerful, open source, object-relational database system with a strong reputation for reliability, feature robustness and performance.

To export data in a View in Mammoth to the PostgresSQL database on a remote server:

  1. Open Export and Share > Export to database > Already existing database > PostgresSQL;

  2. Enter your database credentials - Host, Username, Password, Database and the Table name;

  3. Tick the checkbox “Keep at the end of the pipeline” to keep the export task at the end of your pipeline. Any task performed will then be added to the Pipeline before the export task;

  4. Tick the checkbox “include hidden columns” to export the hidden columns;

  5. Validate the credentials;

  6. Once it is validated, click on “Apply.”

    PostgresSQL credentials

    Fig. 154 Enter PostgreSQL credentials and apply

A table with data from the View will then be created in the remote database. The export will also be recorded as a Task in the pipeline.

Note

  1. Apart from the table name, all other requirements are mandatory. If a table name is not provided, it will be auto-generated and visible in the notification corresponding to the task;

  2. If a table is present in the database with the same name as the table name mentioned in the export task, the existing table will be deleted and a new table will be created with that name;

  3. Ensure you have the write access to the database.