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.