PostgreSQL

Guides to the commands and catalogue queries, explanations for the errors you actually hit, and a native Mac client for when you would rather not use psql at all.

Guides

The questions people hit when Postgres does not behave like MySQL.

List tables, databases, schemas and users

Postgres has no SHOW TABLES. The psql commands \dt, \l, \du and \dn, plus the information_schema and pg_catalog queries that work from application code.

Error library

Explanations for 47 PostgreSQL errors, each with what causes it and how to fix it.

PostgreSQL error library

From duplicate key violations and foreign key errors to lock timeouts, deadlocks and connection limits. Every page has a real reproduction and a fix.

Free tools

Browser-based, nothing to install, nothing uploaded.

SQL formatterFree

Paste messy SQL, get readable SQL. Supports PostgreSQL syntax alongside MySQL, SQL Server and SQLite.

The app

FluentDB is the native macOS client.

PostgreSQL client for Mac

A native Mac GUI for Postgres with an AI co-pilot, inline editing, JSONB and array support, and SSH tunnelling.

pgAdmin alternative

How FluentDB compares with pgAdmin, including where pgAdmin is the better choice.

Stop wrestling
with your database.

One database client, one payment, yours forever.

Download for Mac

If FluentDB has not replaced your current client within 14 days, we refund you. No questions asked.