SQLite: No Column Names In Output of Select Statement

Question

I am new to SQLite and trying to work my way through the basics. The problem is when I give it a simple command:

select * from newTable;

The output is as follows:

GoodState|GoodCapital ShittyState|Raleigh

Which does not provide the column names on the output. My column names are: State and State_Capital

Is there any option available to make the column names show up on the top of the columns outputted like in MySql?

user3081519 · Accepted Answer · 2014-04-19 01:03:50Z

4

Oh. My bad. I should've googled more thoroughly.

The answer is:

.headers on

This enabled column headers in output.

answered Apr 19, 2014 at 1:03

2,9655 gold badges27 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Max MacLeod · Accepted Answer · 2023-09-15 13:08:41Z

Please, if I may be allowed to supplement the answer with the command-line alternative:

sqlite3 -noheader foo.db "select * from newTable"