Pages

Friday, August 4, 2017

PostgreSQL pager pspg is ready to work

I spent lot of time on work on pspg. These points are done:
  • support for expanded mode
  • fixed resizing
  • two new styles
  • start is significantly faster
  • lot of display errors was fixed
 This code should be compiled from source code. If you want to test it - you need develop packages of ncursesw. If you don't need wide char support, you can compile pspg against ncurses library (in this case a Makefile should be modified).

Usage:
\setenv PAGER 'pspg -s 2'
\pset pager always
select * from pg_stat_activity;

4 comments:

  1. Wondeful!

    I wonder if psql + some external programs could be used to neatly implements some forms/crud/ui, sort of like old dBaseIII worked.

    ReplyDelete
  2. @Lacanoid One: theoretically it is possible - probably you can write bigger application with combination psql + pdmenu + pspg + dialog + bash.

    ReplyDelete
  3. @Lacanoid One - I though about cutting TUI from midnight commander - there is menu system, menu builder and some form of nice form support. I am sure so some TUI application builder + psql + plpgsql can be useful in these days still.

    ReplyDelete