jadaradix/sqlite-bash-list-columns.sh

## sqlite-bash-list-columns.sh
#!/bin/bash
# output: id, name, age

DATABASE_PATH="database.db";
TABLE_NAME="table";

LIST=$(sqlite3 $DATABASE_PATH "PRAGMA table_info($TABLE_NAME)");
for ROW in $LIST; do
  printf $ROW | awk '{split($0,a,"|"); printf "%s, ", a[2]}';
done
	#!/bin/bash
	# output: id, name, age

	DATABASE_PATH="database.db";
	TABLE_NAME="table";

	LIST=$(sqlite3 $DATABASE_PATH "PRAGMA table_info($TABLE_NAME)");
	for ROW in $LIST; do
	printf $ROW \| awk '{split($0,a,"\|"); printf "%s, ", a[2]}';
	done