I hope this question it's not so trivial as I couldn't find answer with Google
I have sqlite3 database with many tables which have same columns. I would like to list single column from all tables in database, but couldn't find a way to do so
From sqlite3 CLI client, something like:
sqlite3 -line my_db.db 'select my_column from *'
but, of course above does not work