pspg

Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.

BSD-2-CLAUSE License

Downloads
186
Stars
2.5K
Committers
33

Bot releases are hidden (Show)

pspg - 2.6.3

Published by okbob almost 5 years ago

Use pkg-config for info about libpq instead pg_config.

pspg - 2.6.1

Published by okbob almost 5 years ago

There is only small change - users can set a string that can be used instead NULL value in csv and tsv formats.

pspg - 2.6.0

Published by okbob almost 5 years ago

tsv format support

pspg - 2.5.5

Published by okbob almost 5 years ago

minor enhancements

pspg - 2.5.4

Published by okbob almost 5 years ago

  • fix entering string on CentOS 7.7
  • try to process -F without ncurses start
  • infrastructure cleaning
pspg - 2.5.3

Published by okbob almost 5 years ago

fix spec file - there is dependency on libpq now
internal functions for performance monitoring

pspg - 2.5.2

Published by okbob almost 5 years ago

bugfixes

pspg - 2.5.0

Published by okbob almost 5 years ago

  • pspg can work like PostgreSQL client - possibility to display result of query to Postgres
  • watch mode support - the query to Postgres can be repeated every n seconds
  • non interactive mode - pspg can be used just like csv formatter
pspg - 2.1.8

Published by okbob about 5 years ago

small hack - freeze 2 cols by default on PostgreSQL versions where oid col is visible

pspg - 2.1.7

Published by okbob about 5 years ago

fix one minor ui bug

pspg - 2.1.3

Published by okbob about 5 years ago

fix loading configuration

pspg - 2.1.2

Published by okbob about 5 years ago

Different heuristics for numeric column detection

pspg - 2.1.1

Published by okbob about 5 years ago

fix using size_t type

pspg - 2.1.0

Published by okbob about 5 years ago

This version of pspg can be used as csv viewer

pspg - 2.0.5

Published by okbob about 5 years ago

fix broken force uni border

pspg - 2.0.4

Published by okbob about 5 years ago

few possible crash bugfixes

pspg - 2.0.3

Published by okbob about 5 years ago

bugfix release

pspg - 2.0.2

Published by okbob about 5 years ago

This release allows sort by text columns too. It uses strxfrm function - this function doesn't work correctly on some platforms (like BSD) due old bug in glibc. Linux should be ok.

pspg - 2.0.1

Published by okbob about 5 years ago

New feature - sort by selected (by vertical cursor) column

pspg - 1.9.0

Published by okbob about 5 years ago

Sort by numeric column support

Package Rankings
Top 10.28% on Alpine-v3.16
Top 23.55% on Formulae.brew.sh
Top 9.65% on Alpine-v3.15
Top 9.74% on Alpine-v3.10
Top 8.43% on Alpine-v3.14
Top 4.46% on Alpine-v3.18
Top 7.82% on Alpine-v3.13
Top 8.02% on Alpine-v3.9
Top 7.91% on Alpine-v3.12
Top 7.72% on Alpine-v3.7
Top 8.41% on Alpine-v3.8
Top 8.2% on Alpine-v3.11
Top 11.07% on Alpine-v3.17
Top 7.65% on Alpine-edge
Badges
Extracted from project README
Stand With Ukraine Video presentation