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 photosAll times are UTC
Ukraine
I started running short on disk space for the non-production FreshPorts hosts. This time, I have decided to ask for donations. See my recent blog post which points to my Patreon account.
Port details
pspg Tabular data pager designed to be used with psql
5.8.12 databases on this many watch lists=2 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 5.8.11Version of this port present on the latest quarterly branch.
Maintainer: bofh@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-11-22 18:51:44
Last Update: 2025-08-03 18:41:14
Commit Hash: 41df8a9
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
License: BSD2CLAUSE
WWW:
https://github.com/okbob/pspg
Description:
pspg is a small specialized pager designed to work with tables. Its primary purpose is to work as PostgreSQL pager, but MySQL is supported too. Main features include the ability to freeze first few rows/columns, possibility to sort data by specified numeric column and configurable color themes.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
pkg-plist: as obtained via: make generate-plist
Expand this list (5 items)
Collapse this list.
  1. bin/pspg
  2. share/man/man1/pspg.1.gz
  3. /usr/local/share/licenses/pspg-5.8.12/catalog.mk
  4. /usr/local/share/licenses/pspg-5.8.12/LICENSE
  5. /usr/local/share/licenses/pspg-5.8.12/BSD2CLAUSE
Collapse this list.
Dependency lines:
  • pspg>0:databases/pspg
To install the port:
cd /usr/ports/databases/pspg/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pspg
  • pkg install pspg
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pspg
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1754156760 SHA256 (okbob-pspg-5.8.12_GH0.tar.gz) = 9f74c236944bea79586a3a12ab9d36735bfa62a92a8d7953e8c1ff5c108277af SIZE (okbob-pspg-5.8.12_GH0.tar.gz) = 2447085

Packages (timestamps in pop-ups are UTC):
pspg
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest5.8.125.8.124.0.15.8.125.8.12-3.1.5-
FreeBSD:13:quarterly5.8.115.8.115.7.45.8.115.8.115.7.45.7.45.7.4
FreeBSD:14:latest5.8.125.8.125.7.15.8.125.8.125.7.4-5.7.4
FreeBSD:14:quarterly5.8.115.8.11-5.8.115.8.115.7.45.7.45.7.4
FreeBSD:15:latest--n/a5.8.11n/a5.7.45.7.45.7.4
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
  2. libncurses.so.6 : devel/ncurses
  3. pkgconf>=1.3.0_1 : devel/pkgconf
  4. psql : databases/postgresql17-client
  5. autoconf>=2.72 : devel/autoconf
  6. automake>=1.17 : devel/automake
Runtime dependencies:
  1. libncurses.so.6 : devel/ncurses
  2. psql : databases/postgresql17-client
Library dependencies:
  1. libinotify.so : devel/libinotify
  2. libreadline.so.8 : devel/readline
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for pspg-5.8.12: DOCS=on: Build and/or install documentation INOTIFY=on: Use inotify instead of polling PGSQL=on: Work as PostgreSQL interactive client ===> Use 'make config' to modify these settings
Options name:
databases_pspg
USES:
autoreconf compiler:c11 gmake localbase ncurses:port pkgconfig readline pgsql
pkg-message:
For install:
To use pspg as psql pager, add this line to ~/.psqlrc: \setenv PAGER '/usr/local/bin/pspg -bX'
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/okbob/pspg/tar.gz/5.8.12?dummy=/
Collapse this list.

Number of commits found: 109 (showing only 9 on this page)

«  1 | 2 

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.9.1
29 Dec 2017 22:20:06
Revision:457549Original commit files touched by this commit
joneum search for other commits by this committer
databases/pspg: Update from 0.9.0 to 0.9.1

PR:		224711
Submitted by:	Dmitri Goutnik <dg@syrec.org> (maintainer)
Approved by:	mentors (implicit)
0.9.0
28 Dec 2017 22:21:45
Revision:457484Original commit files touched by this commit
dbaio search for other commits by this committer
databases/pspg: Update to 0.9.0

- Convert to options target helper

Changes:	https://github.com/okbob/pspg/releases/tag/0.9.0

PR:		224655
Submitted by:	Dmitri Goutnik <dg@syrec.org> (maintainer)
0.8.0
16 Dec 2017 09:01:01
Revision:456463Original commit files touched by this commit
yuri search for other commits by this committer
databases/pspg: Update to 0.8.0

PR:		224365
Submitted by:	Dmitri Goutnik <dg@syrec.org>
Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D13507
0.7.5
02 Dec 2017 02:25:11
Revision:455331Original commit files touched by this commit
dbaio search for other commits by this committer
databases/pspg: Update to 0.7.5

Changes:	https://github.com/okbob/pspg/releases/tag/0.7.5

PR:		224020
Submitted by:	Dmitri Goutnik <dg@syrec.org> (maintainer)
0.7.4
27 Nov 2017 22:46:12
Revision:454997Original commit files touched by this commit
dbaio search for other commits by this committer
databases/pspg: Update to 0.7.4

Changes:	https://github.com/okbob/pspg/releases/tag/0.7.4

PR:		223923
Submitted by:	Dmitri Goutnik <dg@syrec.org> (maintainer)
0.7.3
26 Nov 2017 17:51:58
Revision:454912Original commit files touched by this commit
dbaio search for other commits by this committer
databases/pspg: Update to 0.7.3

Changes:	https://github.com/okbob/pspg/releases/tag/0.7.3

PR:		223883
Submitted by:	Dmitri Goutnik <dg@syrec.org> (maintainer)
0.7.2
25 Nov 2017 18:06:42
Revision:454888Original commit files touched by this commit
tcberner search for other commits by this committer
Update databases/pspg to 0.7.2

PR:		223868
Submitted by:	Dmitri Goutnik <dg@syrec.org> (maintainer)
0.6_1
23 Nov 2017 05:48:21
Revision:454739Original commit files touched by this commit
yuri search for other commits by this committer
databases/pspg: Update pkg-message: Improved the alias suggestion

PR:		223805
Submitted by:	Dmitri Goutnik <dg@syrec.org>
Reported by:	Christoph Moench-Tegeder <cmt@burggraben.net>
Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D13195
0.6
22 Nov 2017 18:51:37
Revision:454699Original commit files touched by this commit
yuri search for other commits by this committer
New port: databases/pspg: Tabular data pager designed to be used with psql

PR:		223694
Submitted by:	Dmitri Goutnik <dg@syrec.org>
Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D13170

Number of commits found: 109 (showing only 9 on this page)

«  1 | 2