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 - 5.2.1

Published by okbob about 3 years ago

minor bugfixes and enhancing

pspg - 5.2.0

Published by okbob about 3 years ago

  • progressive data load
  • the text of helps can be little bit formatted
pspg - 5.1.3

Published by okbob about 3 years ago

fix minor bugs

  • don't do unwanted reload of history file after theme change
  • ^C (sigint) is working in edit line again
pspg - 5.1.2

Published by okbob over 3 years ago

bugfix reprint on exit doesn't work when pspg was executed as pager

pspg - 5.1.1

Published by okbob over 3 years ago

fix tabcomplete bug - after switch to nonl mode the ENTER returns code 13, not code 10

pspg - 5.1.0

Published by okbob over 3 years ago

  • new possibility to temporal switch to primary screen by pressing Ctrl o
  • refactoring of input events processing
pspg - 5.0.5

Published by okbob over 3 years ago

There is new option --no-last-row-search. When you run pspg with this option, then editing of searching patterns doesn't use previous pattern as default (it can be taken from histrory). The new behaviour is same like in vim, less, more.

In this release I cleaned some issues detected by valgrind - but these issues was invisible for users, so this cleaning is invisible for users too.

pspg - 5.0.4

Published by okbob over 3 years ago

code refactoring and cleaning

pspg - 5.0.3

Published by okbob over 3 years ago

code cleaning only

pspg - 5.0.2

Published by okbob over 3 years ago

  • fix csv export (broken quote escaping)
  • fix possible tabcomplete crash
  • new export formats - SQL values and pipe separated values (this is just trimmed text without any other escaping)
pspg - 5.0.1

Published by okbob over 3 years ago

fix two possible crashes

pspg - 5.0.0

Published by okbob over 3 years ago

  • new light PaperColor theme
  • possibility to set nullstr used by export routines
  • introduction interactive command line and backslash commands
  • \save, \copy, \theme, \quit, \order, \orderd and \search commands
  • possibility to push export output to some program by using pipe
  • possibility to search only in selected area
pspg - 4.6.3

Published by okbob over 3 years ago

  • another try to reduce flickering related to too frequented mouse events
  • introduction of PSPG_CONF and PSPG_HISTORY env variables
pspg - 4.6.1

Published by okbob over 3 years ago

fix segfault crash when after change of theme

pspg - 4.6.0

Published by okbob over 3 years ago

  • --menu-always ensure active top bar menu all time
    • modify theme 9
    • fix detection of last row of table when border = 1
pspg - 4.5.0

Published by okbob over 3 years ago

fix stream mode on apple (/dev/tty cannot be used with poll function)
new query stream mode - queries for integrated postgres client are read from stream

pspg - 4.4.0

Published by okbob over 3 years ago

for some cases, an field with multiline value can be exported as one value.

pspg - 4.3.1

Published by okbob over 3 years ago

new option --no-sleep - fix issues with scrolling freezing on cygwin

pspg - 4.3.0

Published by okbob over 3 years ago

an range for export can be selected by mouse or by keyboard

pspg - 4.2.1

Published by okbob over 3 years ago

better implementation of interaction between scrollbar and data window

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