Hi, This pragma works for me (3.2.7):
sqlite> pragma short_column_names=0; sqlite> pragma full_column_names=1; sqlite> .header on Set short_ = 0 and full_ = 1 You can check the curent value of pragma directive with: pragma <directive_name> sqlite> pragma short_column_names; 0 // -> display of short column name deactivated sqlite> pragma full_column_names; 1 // -> display of full column name ACTIVATED Regards Radu Lodina