starsuper.blogg.se - Postgresql client for mac

Postgresql client for mac password#

So it lacks polish, sure, but it’s WAY faster and easier than typing out the queries from the CLI. The query and the results are in different “tabs” but you can’t switch from the query tab to the results tab without exiting the tab because of the keyboard-helper bar along the bottom (the one that’s still there even when you’re on a hardware keyboard). The interface can’t run an individual query, only everything that’s in the current window.

It crashes sometimes (but brings all your saved queries right back up). I’ve been creating tables, inserting data, parsing tens of thousands of records without trouble. And that’s what I am, so it’s the only viable option for iPad as far as I can see. This app has a fantastic hobbyist-level price. The competition have enterprise-level subscription rates. Look, for the price, you’re not going to do better.

Browsing of DB structure within a query or a record editor.

Import of CSV or MSAccess(MDB/ACCDB) tables.

Export data grid to CSV, HTML, Excel and MSAccess(XML) format.

Geometry/geography data viewer (with PostGIS extension).

Table data: add, edit and delete record.

Table structure: new table, add column, alter or drop.

View ER Diagram (interactive and with PNG/PDF export).

Free query with assisted composition and plan analysis.

Browse of Standard View, Materialized Views, Functions and Procedures (v11).

Table structure: rename and drop for tables and columns.

Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS).

Postgresql client for mac password#

SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key).

Connection over SSL/TLS encryption with support for X.509 Certificate authentication.

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