PostgreSQL Client 37.0

The PostgreSQL Client offers seamless access to your PostgreSQL database, eliminating the need for any server setup. With its sleek and user-friendly iOS interface, managing your data has never been easier.

Key Features:

• Secure SSL/TLS encryption for connections, supporting X.509 Certificate authentication
• Built-in SSH tunnel with password or key authentication options (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Support for multiple database authentication methods: plain, MD5, and SASL (including SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Data management features including table browsing, filtering, and sorting
• Flexible options to rename and drop tables and columns
• Browsing capabilities for Standard View, Materialized Views, Functions, and Procedures (v11)
• Ability to view and edit Functions and Procedures
• Effortless free-form query composition with assisted suggestions and plan analysis
• Access to valuable database and table statistics
• Simple viewing and management of sessions
• Interactive server status graphs for monitoring purposes
• ER Diagram visualization with both interactive exploration and the ability to export as PNG/PDF
• Built-in server log file browser for easy log analysis

Pro Features (available through in-app purchase):

• Login information securely stored in the Keychain (local or iCloud)
• Enhanced table structure management capabilities such as creating new tables, adding columns, altering, or dropping them
• Convenient table data management options including adding, editing, and deleting records
• Blob preview and export functionality
• Blob updating directly from iOS Photos or Files
• Specialized viewer for geometry and geography data (with PostGIS extension)
• Data grid export to various formats including CSV, HTML, Json, NDJson, Excel, and MSAccess(XML)
• Table export to CSV, NDJson, and SQLite formats
• Importing of CSV, NDJson, or MSAccess(MDB/ACCDB) tables
• Easily explore the database structure while working within a query or record editor
• iCloud Sync for seamless synchronization of saved query statements
• Support for shortcuts to expedite workflow efficiency
• Real-time updates to tables/views displayed within the grid view

The PostgreSQL Client has been extensively tested on PostgreSQL versions 9.5, 9.6, 10, 11, and 12.

For any feedback or suggestions, please email maguolo.ios@outlook.com.