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:
Open Data Preparation > Exports > PostgresSQL;
Enter your database credentials - Host, Username, Password, Database and the Table name;
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;
Tick the checkbox “include hidden columns” to export the hidden columns;
Validate the credentials;
Once it is validated, click on “Apply.”
A table with data from the View will then be created in the remote database.
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 action;
If a table is present in the database with the same name as the table name mentioned in the export action, the existing table will be deleted and a new table will be created with that name;
Ensure you have the write access to the database.