The .header command controls whether rsql displays a header row (column names) above query results. By default, the header is displayed, making it easier to interpret data, especially for wide tables or unfamiliar queries.

Usage

.header <on|off>

When to use

  • Enable the header (on) for interactive exploration, data analysis, or when sharing results with others.
  • Disable the header (off) for minimal output, such as when exporting data for further processing.

Examples

Show the current header setting:

.header

Enable the header:

.header on

Disable the header:

.header off

Troubleshooting

  • If you do not see column names, ensure .header on is set.
  • For scripting or exporting, use .header off to avoid extra lines in output files.

Demonstration