.\" DO NOT MODIFY THIS FILE!  It was generated by help2man 1.49.3.
.TH PSPG "1" "February 2023" "pspg 5.7.2" "User Commands"
.SH NAME
pspg \- PostgreSQL pager
.SH DESCRIPTION
pspg is a Unix pager designed for table browsing.
.SS "Usage:"
.IP
pspg [OPTION] [file]
.SS "General options:"
.TP
\fB\-\-about\fR
about authors
.TP
\fB\-\-help\fR
show this help
.TP
\fB\-V\fR, \fB\-\-version\fR
show version
.TP
\fB\-\-info\fR
show info about libraries and system
.TP
\fB\-\-direct\-color\fR
use direct true colors
.TP
\fB\-f\fR, \fB\-\-file\fR=\fI\,FILE\/\fR
open file
.TP
\fB\-F\fR, \fB\-\-quit\-if\-one\-screen\fR
quit if content is one screen
.TP
\fB\-\-clipboard\-app\fR=\fI\,NUM\/\fR
specify app used by copy to clipboard (1, 2, 3)
.TP
\fB\-\-esc\-delay\fR=\fI\,NUM\/\fR
specify escape delay in ms (\fB\-1\fR inf, 0 not used, )
.TP
\fB\-\-interactive\fR
force interactive mode
.TP
\fB\-\-ignore_file_suffix\fR
don't try to deduce format from file suffix
.TP
\fB\-\-ni\fR
not interactive mode (only for csv and query)
.TP
\fB\-\-no\-mouse\fR
don't use own mouse handling
.TP
\fB\-\-no\-progressive\-load\fR
don't use progressive data load
.HP
\fB\-\-no\-sigint\-search\-reset\fR
.TP
\fB\-\-no\-watch\-file\fR
don't watch inotify event of file
without reset searching on sigint (CTRL C)
.TP
\fB\-\-no\-sleep\fR
without waits against flickering
.TP
\fB\-\-no\-xterm\-mouse\-mode\fR
don't use optional xterm mouse mode
.TP
\fB\-\-only\-for\-tables\fR
use std pager when content is not table
.TP
\fB\-\-on\-sigint\-exit\fR
exit on sigint(CTRL C or Escape)
.TP
\fB\-\-pgcli\-fix\fR
try to fix some pgcli related issues
.TP
\fB\-\-querystream\fR
read queries from stream forever
.TP
\fB\-\-quit\-on\-f3\fR
exit on F3 like mc viewers
.TP
\fB\-\-rr\fR=\fI\,ROWNUM\/\fR
rows reserved for specific purposes
.TP
\fB\-\-stream\fR
read input forever
.TP
\fB\-X\fR, \fB\-\-reprint\-on\-exit\fR
preserve content after exit
.SS "Output format options:"
.TP
\fB\-a\fR, \fB\-\-ascii\fR decor
force ascii
.TP
\fB\-b\fR, \fB\-\-blackwhite\fR
black\-white style
.TP
\fB\-s\fR, \fB\-\-style\fR=\fI\,N\/\fR
set color style number (0..23)
.TP
\fB\-\-bold\-labels\fR
row, column labels use bold font
.TP
\fB\-\-bold\-cursor\fR
cursor use bold font
.TP
\fB\-\-border\fR
type of borders (0..2)
.TP
\fB\-\-custom\-style\fR=\fI\,NAME\/\fR
name of custom color style
.TP
\fB\-\-double\-header\fR
header separator uses double lines
.TP
\fB\-\-force\-uniborder\fR
replace ascii borders by unicode borders
.TP
\fB\-\-hide\-header\-line\fR
hides header line
.TP
\fB\-\-highlight\-odd\-rec\fR
use special style for odd records
.TP
\fB\-\-ignore\-bad\-rows\fR
rows with wrong column numbers are ignored
.TP
\fB\-\-null\fR=\fI\,STRING\/\fR
STRING used instead NULL
.PP
Searching options
.TP
\fB\-g\fR \fB\-\-hlite\-search\fR, \fB\-G\fR \fB\-\-HILITE\-SEARCH\fR
don't highlight lines for searches
.TP
\fB\-i\fR \fB\-\-ignore\-case\fR
ignore case in searches that do not contain uppercase
.TP
\fB\-I\fR \fB\-\-IGNORE\-CASE\fR
ignore case in all searches
.SS "Interface options:"
.TP
\fB\-c\fR, \fB\-\-freezecols\fR=\fI\,N\/\fR
freeze N columns (0..9)
.TP
\fB\-\-less\-status\-bar\fR
status bar like less pager
.TP
\fB\-\-line\-numbers\fR
show line number column
.TP
\fB\-\-menu\-always\fR
show top bar menu every time
.TP
\fB\-\-no\-bars\fR, \fB\-\-no\-commandbar\fR, \fB\-\-no\-topbar\fR
don't show bottom, top bar or both
.TP
\fB\-\-no\-cursor\fR
row cursor will be hidden
.TP
\fB\-\-no\-last\-row\-search\fR
don't use the last pattern when starting a new search
.TP
\fB\-\-no\-scrollbar\fR
don't show scrollbar
.TP
\fB\-\-no\-sound\fR
don't use beep when scroll is not possible
.TP
\fB\-\-tabular\-cursor\fR
cursor is visible only when data has table format
.TP
\fB\-\-vertical\-cursor\fR
show vertical column cursor
.SS "Input format options:"
.TP
\fB\-\-csv\fR
input stream has csv format
.TP
\fB\-\-csv\-separator\fR
char used as field separator
.TP
\fB\-\-csv\-header\fR [on/off]
specify header line usage
.TP
\fB\-\-skip\-columns\-like=\fR"SPACE SEPARATED STRING LIST"
columns with substr in name are ignored
.TP
\fB\-\-tsv\fR
input stream has tsv format
.SS "On exit options:"
.TP
\fB\-\-on\-exit\-reset\fR
sends reset terminal sequence "\e33c"
.TP
\fB\-\-on\-exit\-clean\fR
sends clean terminal sequence "\e033[2J"
.TP
\fB\-\-on\-exit\-erase\-line\fR
sends erase line terminal sequence "\e033[2K\er"
.TP
\fB\-\-on\-exit\-sgr0\fR
sends sgr0 terminal sequence "\e033[0;10m"
.SS "Watch mode options:"
.TP
\fB\-q\fR, \fB\-\-query\fR=\fI\,QUERY\/\fR
execute query
.TP
\fB\-w\fR, \fB\-\-watch\fR time
the query (or read file) is repeated every time (sec)
.PP
Connection options
.TP
\fB\-d\fR, \fB\-\-dbname\fR=\fI\,DBNAME\/\fR
database name
.TP
\fB\-h\fR, \fB\-\-host\fR=\fI\,HOSTNAME\/\fR
database server host (default: "local socket")
.TP
\fB\-p\fR, \fB\-\-port\fR=\fI\,PORT\/\fR
database server port (default: "5432")
.TP
\fB\-U\fR, \fB\-\-username\fR=\fI\,USERNAME\/\fR
database user name
.TP
\fB\-W\fR, \fB\-\-password\fR
force password prompt
.SS "Debug options:"
.TP
\fB\-\-log\fR=\fI\,FILE\/\fR
log debug info to file
.TP
\fB\-\-wait\fR=\fI\,NUM\/\fR
wait NUM seconds to allow attach from a debugger
.PP
pspg shares lot of key commands with less pager or vi editor.