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.
Volunteers wanted to help translate FreshPorts
Port details
pgtui Terminal UI for PostgreSQL
0.3.0_2 databases 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 0.3.0_2Version of this port present on the latest quarterly branch.
Maintainer: olgeni@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2026-08-23 23:21:07
Last Update: 2026-10-08 20:44:12
Commit Hash: 031fc6b
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_2/catalog.mk
  3. /usr/local/share/licenses/pgtui-0.3.0_2/LICENSE
  4. /usr/local/share/licenses/pgtui-0.3.0_2/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
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64leriscv64
FreeBSD:13:latest--n/an/an/an/an/an/an/a
FreeBSD:13:quarterly--n/an/an/an/an/an/an/a
FreeBSD:14:latest0.3.0_10.3.0_1--0.3.0_1----
FreeBSD:14:quarterly-0.3.0_1--0.3.0_2----
FreeBSD:15:latest0.3.0_10.3.0_1n/a-n/an/a---
FreeBSD:15:quarterly0.3.0_10.3.0_1n/a-n/an/a---
FreeBSD:16:latest0.3.0_10.3.0_1n/a-n/an/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. go127 : lang/go127
Fetch dependencies:
  1. go127 : lang/go127
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: 3

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.3.0_2
08 Oct 2026 20:44:12
commit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffccommit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffccommit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffccommit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffc files touched by this commit
Dag-Erling Smørgrav (des) search for other commits by this committer
various: Bump Go ports
0.3.0_1
03 Sep 2026 04:50:55
commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
many: Bump go ports for 1.26.8 and 1.27.1
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: 3