Paginate 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.

To redirect the output to your favorite paging utility, use any one of the following methods:

  • Use the --pager nuosql option

    For example:

    nuosql test --user cloud --password user --pager more
nuosql test --user cloud --password user --pager "less -inSFX"

  • Add commands to the nuosql configuration file

    For example:

    pager "less -inSFX"

  • Use the SET PAGER command.