Engines
PostgreSQL
Bobby Tables connects to PostgreSQL servers and opens each connection in a SQL workspace with a catalog sidebar, table grids, a structure editor and a SQL editor.
Where to find it
| Action | How |
|---|---|
| Choose PostgreSQL | New connection, ⌘N (Ctrl+N), then PostgreSQL under Choose a provider |
| Fill the form from a URL | Use connection URL with a postgres:// or postgresql:// URL, then Fill fields |
| Default port | 5432 |
The chooser lists PostgreSQL as a Server database. A postgresql:// URL that uses port 26257 or a CockroachDB Cloud host fills the form as CockroachDB instead.
Connecting
The form asks for Host, Port, User, Database and Password. Test connection reports the version string the server returns and the round trip, and refuses a CockroachDB server selected as PostgreSQL. The TLS and SSH tunnel sections set certificates and reach a private server, as described in SSH and TLS. Open in read-only mode sets default_transaction_read_only on the session and disables editing in the interface.
What works
- Browse schemas, tables, views and rows in the table grid.
- Stage inserts, updates and deletes, then commit them in one transaction, as described in Editing.
- Change columns, indexes and keys in the Structure tab, with the DDL run inside a transaction.
- Take a snapshot with the built-in engine or an installed
pg_dump. - Draw a schema diagram from declared foreign keys.
- Format result columns with result directives.
- Stop a running statement with
Cancel, ⌘. (Ctrl+.), which cancels it out of band. - Run
Explain, ⌘⇧E (Ctrl+Shift+E), orExplain Analyze, ⌘⇧⌥E (Ctrl+Shift+Alt+E), in the SQL editor.
Engine notes
Explain Analyze runs the statement and requests timings and buffer counts. For anything other than a SELECT, the app asks Run Explain Analyze? first and rolls the statement back afterwards. Server notices appear with the results and can be dismissed. The catalog reads pg_catalog directly rather than information_schema.
Good to know
- Structure changes run in one transaction, so a failed statement leaves the table as it was.
- Use
Switch database, ⌘K (Ctrl+K), to move to another database on the same server. - A CockroachDB server is refused under the PostgreSQL provider. Choose CockroachDB for it.
LISTENnotifications are not shown.