Apps in this category may contain mild or occasional cartoon, fantasy or real-life violence, as well as occasional or mild adult, sexually suggestive or horrifying content and may not be suitable for children under 9 years of age.

12+

Apps in this category may contain occasional mild indecent language, frequent or intense cartoon or real-life violence, minor or occasional adult or sexually suggestive material, and simulated gambling, and may be for children under 12 years of age.

17+

You must be at least 17 years old to access this App.

Apps in this category may contain frequent and intense offensive language; Frequent and intense cartoon, fantasy or realistic violence: frequent and intense adult, scary and sexually suggestive subjects: as well as sexual content, nudity, tobacco, alcohol and drugs, may not be suitable for children under 17 years of age.

PostgreSQL Client 螢幕截圖

iPad

iPhone

About PostgreSQL Client

PostgreSQL Client allow you to access your PostgreSQL database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)

Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.

For feedback or suggestions write to maguolo.ios@outlook.com