PostgreSQL

PostgreSQL, often simply Postgres, is an open source object-relational database management system (RDBMS) known for its robustness, reliability, feature-richness. and standards compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications, whether on the same host or running on another host across a network. It is a powerful and reliable database management system suitable for a wide range of applications, from small projects to enterprise-level systems.

Key features of PostgreSQL:

ACID Compliance
Advanced Data Types
MVCC
Rich Indexing
Extensible
Full-text Search
Internationalization
Programming Interfaces
Procedural Languages
Foreign Data Wrappers
Replication
Robustness
Community Support
Cross Platform

PostgreSQL is widely used in a variety of applications from small systems where robustness and data integrity are critical, to large applications with complex data workloads and high user concurrency requirements.

Actions:

Insert: Create a new row in a table in specified schema.
Update: Update rows found based on the given where clause entries.
Delete: Delete rows found based on the given where clause entries.
SQL query: Executes the given SQL statement.

Connect with PostgreSQL:

Go to Mation and navigate to My Apps and Add a new connection choosing PostrgeSQL from the list.
Fill in the PostgreSQL version field with the version that you are using.
Fill in the host address field with the Postgres host address (URL without protocol).
Fill in the port field with the Postgres port.
Select whether to use SSL or not.
Fill in the database name field with the Postgres database name.
Fill in the database username field with the Postgres username.
Fill in the password field with the Postgres password.
Click the Submit button on Mation.
Your PostgreSQL connection is now established.
Start using your new PostgreSQL connection with Mation.