notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
After the ports freeze to fix some stuff, the freeze is over. I have some work to do before FreshPorts can start processing commits again before it can start processing again. I've created an issue for that.
Port details
pgtui Terminal UI for PostgreSQL
0.3.0 databasesnew! on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: olgeni@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2026-08-23 23:21:07
Last Update: 2026-08-23 23:17:54
Commit Hash: cb75dbe
License: APACHE20
WWW:
https://github.com/pgplex/pgtui
Description:
pgtui is a terminal user interface for PostgreSQL, built with the Bubble Tea framework. It browses databases, schemas and tables in a tree view, filters rows interactively, formats and navigates JSONB values, and runs ad-hoc SQL with the results shown in tabs. A command palette gives keyboard access to commands, tables and recent queries. Other features include saved query favorites, discovery of local PostgreSQL instances, connection history, vim-style motions and optional mouse support.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (4 items)
Collapse this list.
  1. bin/pgtui
  2. /usr/local/share/licenses/pgtui-0.3.0/catalog.mk
  3. /usr/local/share/licenses/pgtui-0.3.0/LICENSE
  4. /usr/local/share/licenses/pgtui-0.3.0/APACHE20
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • pgtui>0:databases/pgtui
To install the port:
cd /usr/ports/databases/pgtui/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pgtui
  • pkg install pgtui
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pgtui
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1787515457 SHA256 (go/databases_pgtui/pgtui-v0.3.0/v0.3.0.mod) = 60a9e96e269c75ff144a621ad32c7e30130739b0254136e78ed862863b2efe7f SIZE (go/databases_pgtui/pgtui-v0.3.0/v0.3.0.mod) = 2635

Expand this list (2 items)

Collapse this list.

SHA256 (go/databases_pgtui/pgtui-v0.3.0/v0.3.0.zip) = 1afb2219904fdbe7088368b0ddde97c131c313d2f7d1c1d372a825fa982243a4 SIZE (go/databases_pgtui/pgtui-v0.3.0/v0.3.0.zip) = 9730907

Collapse this list.


Packages (timestamps in pop-ups are UTC):
pgtui
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest----0.3.0---
FreeBSD:14:quarterly--------
FreeBSD:15:latest-0.3.0n/a-n/an/a--
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. go126 : lang/go126
Fetch dependencies:
  1. go126 : lang/go126
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_pgtui
USES:
go:modules zip
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://proxy.golang.org/github.com/pgplex/pgtui/@v/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.3.0
23 Aug 2026 23:17:54
commit hash: cb75dbec9993bb0628d51ca4771d8c82ee1f7325commit hash: cb75dbec9993bb0628d51ca4771d8c82ee1f7325commit hash: cb75dbec9993bb0628d51ca4771d8c82ee1f7325commit hash: cb75dbec9993bb0628d51ca4771d8c82ee1f7325 files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/pgtui: New port: Terminal UI for PostgreSQL

Number of commits found: 1