Paginating NuoDB SQL Output
The SET PAGER command and --pager option are supported on Linux systems only.
|
By default, when nuosql
delivers the results of a query, output is simply sent to stdout
. If the result set returned from the query is particularly large, it may be useful to redirect the output to your favorite paging utility, e.g. more
or less
. Furthermore, you can pass arguments to the paging tool.
You can achieve this by using the --pager
command line option as in these examples:
nuosql test --user cloud --password user --pager more
nuosql test --user cloud --password user --pager "less -inSFX"
Or by adding commands to $HOME/.nuosql.config
file, for example:
pager "less -inSFX"
Or by using the SET PAGER
command. See SET
for more information.