content/blog/miscellaneous/sqlite-pretty-print.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

---
title: "SQLite pretty print"
date: 2019-06-19
description: How to pretty print your SQLite output
tags:
  - SQLite
---

## The solution
In `~/.sqliterc` add the following :
{{< highlight sh >}}
.mode column
.headers on
.separator ROW "\n"
.nullvalue NULL
{{< /highlight >}}