Appearance
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.