LinuxCommandLibrary

pspg

Unix pager designed for tables and PostgreSQL output

TLDR

Use as the pager for psql
$ export PAGER=pspg
copy
View a CSV file
$ pspg --csv < [file.csv]
copy
View a TSV file
$ pspg --tsv < [file.tsv]
copy

SYNOPSIS

pspg [options]

DESCRIPTION

pspg is a Unix pager with rich functionality designed for working with tables. Originally created for PostgreSQL's psql, it also supports MySQL and works as a general CSV/TSV viewer. It features frozen column headers, searching, row/column/block selection, clipboard export, and mouse support.

PARAMETERS

--csv

Read input as CSV format.
--tsv
Read input as TSV format.
--stream
Use streaming mode for psql watch output.

HISTORY

pspg was created by Pavel Stehule (okbob) and is written in C.

SEE ALSO

less(1), psql(1), ov(1)

> TERMINAL_GEAR

Curated for the Linux community

Copied to clipboard