The easiest way to get started with PostgreSQL on the Mac

GUI Client Apps

There are many clients for PostgreSQL on the Mac. Below is a list of some of the Mac Apps I found (in alphabetic order).

You can find many more of them on the PostgreSQL Clients page in the PostgreSQL wiki. Some of them are quite powerful; some are still a bit rough.

The default connection parameters are described here. If you need to provide an URL, use postgresql://YOURUSERNAME@localhost/YOURUSERNAME