The .footer command controls whether rsql displays a footer after query results. The footer typically shows summary information such as row counts, execution time, and other metadata. By default, the footer is displayed.

Usage

.footer <on|off>

When to use

  • Enable the footer (on) to see summary information after each query—useful for data analysis and performance monitoring.
  • Disable the footer (off) for a cleaner output, especially when exporting results or scripting.

Examples

Show the current footer setting:

.footer

Enable the footer:

.footer on

Disable the footer:

.footer off

Troubleshooting

  • If you do not see summary information, ensure .footer on is set.
  • For minimal output, use .footer off in combination with .header off and .changes off.

Demonstration