Postico: A Trendy PostgreSQL Client for the Mac

A Modern PostgreSQL Client for the Mac Postico requires macOS 10.10 or later. Version 1.5.20 was released on Nov 4, 2021. Read the Changelist. Also available on the Mac App Store. We also offer Legacy Downloads for older versions of macOS. PostgreSQL is an absurdly powerful database, but there’s no reason why using it should…

Postico: A Trendy PostgreSQL Client for the Mac

A Trendy PostgreSQL Client for the Mac

Postico requires macOS 10.10 or later. Version 1.5.20 became as soon as launched on Nov 4, 2021. Learn the Changelist.
Also available on the Mac App Store. We also offer Legacy Downloads for older variations of macOS.

PostgreSQL is an absurdly highly efficient database, however there is no motive why the use of it could perhaps perhaps additionally merely silent require an developed stage in relational idea.
Postico provides a straightforward to use interface, making Postgres more accessible for novices and experts alike.

Postico will see familiar to somebody who has frail a Mac earlier than.
Actual connect with a database and start working with tables and views.
Originate up with the basics and study about developed points of PostgreSQL as you tear alongside.

Postico is an intuitive app for taking a stare at files.
Filter rows, kind them, rearrange columns.
You’ll want to well additionally see long text or images with ease within the sidebar.
Even connected rows from referenced tables are confirmed.

Edit rows straight, or use the sidebar — a pleasing change for long text. You’ll want to well additionally even alternate a pair of rows accurate now.
Batch saving (with SQL preview) permits you to commit adjustments to a pair of rows in a single transaction.

Table Content View

Add and uncover columns, rename them, alternate forms.
Modify tables and views with out having to undergo in thoughts the ALTER TABLE syntax.

The unified construction editor displays every little thing you may want to uncover out a pair of table.
Feedback and constraints are confirmed valid next to the columns.

Table Structure Editor

Ought to you’d like onerous questions answered, PostgreSQL provides many developed instruments for files analysis:
Frequent table expressions, recursive queries, filter aggregates, window functions.

To uncover entry to these instruments, Postico sports activities a highly efficient inquire of of leer with enhance for a pair of end result gadgets.
The editor has your total no longer new points you demand, like syntax highlighting and automatic indentation.

SQL Query View

Native Journey
Native Cocoa controls make certain consistency.
Keyboard shortcuts practice platform conventions.
Instructions like undo/redo or replica/paste work valid as you will demand.
And naturally, Postico plays fine with other apps and services you exhaust each day.

Brilliant Create
Postico became as soon as designed from the bottom up with Apple’s in vogue make language in thoughts.
Its high resolution art work appears to be like enormous on Retina displays.

Stable out of the sphere
Postico makes use of alternate no longer new encryption: each SSL and SSH will also be frail for proper connections.
Server certificates are continuously validated.
Passwords are saved safely within the gadget keychain.
A warning is confirmed if the server requests a hideous text connection.

Steady Customer Give a increase to
Ought to you will hang a inquire of of, it’s possible you’ll perchance perhaps additionally contact the builders straight —
We personally answer all customer emails.
You’ll want to well now no longer must tackle outsourced enhance agents, and you will never uncover a canned response.

A Accomplice to is the quickest manner to stride a PostgreSQL server within the community.
Since Postico is made by the maintainer of, the two apps co-operate completely.

Optimized for little displays
A slim toolbar conserves vertical display cloak cloak property.
The sidebars will also be hidden to notify more of your files.
And if you happen to don’t want to fracture a single pixel, swap to beefy display cloak cloak mode.

Which variations of PostgreSQL are supported?
Postico helps PostgreSQL 8.0 and later.
We stride automated assessments to make certain compatibility with PostgreSQL 8.4, 9.x, 10, 11, and 12.
Postico also helps database programs derived from PostgreSQL like Amazon Redshift or Greenplum,
and programs that use the PostgreSQL protocol like CockroachDB.

What are the restrictions of the free trial?

  • At most 5 connection favorites
  • Easiest a single window per connection
  • Desk filters are disabled
  • There is no longer any closing date — use the trial so long as you like to hang!

Ought to silent I purchase Postico on the Mac App Store or from your web station?
It be your change! Many purchasers prefer the comfort of the App Store.
You hang all licenses in a single position, and your utility is robotically up to this level.
The retailer on my web station (operated by Fastspring) has greater enhance for alternate clients.
Also, Fastspring funds a decrease fee, so the model on my web station is a miniature bit more affordable.

I equipped a brand current Macbook! How can I switch my license?
Ought to you exhaust migration assistant, your license will possible be transferred robotically.
In every other case start Postico, tear to the “Wait on” menu, prefer out “License Recordsdata”, then click the “Boom their own praises License File” button.
Reproduction that license file to your current computer, and on the current computer traipse it on the Postico icon to instructed.

I misplaced my license file!
Please tear to to recover previously bought licenses.

I work for a utility reseller. Who could perhaps additionally merely silent I contact to uncover quotes?
Please leer this file with files for resellers.

Attain you will hang a grief tracker for worm reports and feature requests?
I’ve attach up a Github repository for public feature requests and worm reports.
But obviously it’s possible you’ll perchance perhaps additionally additionally reach out privately through electronic mail:
Ought to you’d like a worm mounted immediate, imagine following the finest practices for worm reporting.

Read More



“Simplicity, patience, compassion.
These three are your greatest treasures.
Simple in actions and thoughts, you return to the source of being.
Patient with both friends and enemies,
you accord with the way things are.
Compassionate toward yourself,
you reconcile all beings in the world.”
― Lao Tzu, Tao Te ChingBio: About: