PostgresSQL

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

The data in a View in Mammoth can be exported to the PostgresSQL database on a remote server.

  1. Open Data Preparation > Exports > PostgresSQL.

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

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

  4. Enable the checkbox “include hidden columns” if you want the hidden columns to be exported.

  5. Validate the credentials. Once it is validated, click on “Apply”.

    PostgresSQL credentials

A table with data from the View will be created in the remote database.

Note

  1. Except table name, the other requirements are mandatory. If table name is not provided, it will be auto-generated and visible in the notification corresponding to the action.

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

  3. Make sure you have the write access to the database.