Is there a way to get a list of column names in sqlite?

by

You can use sqlite3 and pep-249

import sqlite3
connection = sqlite3.connect('~/foo.sqlite')
cursor = connection.execute('select * from bar')

cursor.description is description of columns

names = list(map(lambda x: x[0], cursor.description))

Alternatively you could use a list comprehension:

names = [description[0] for description in cursor.description]

More Related Contents:

  1. Variable table name in sqlite
  2. Importing a CSV file into a sqlite3 database table using Python
  3. OperationalError: database is locked
  4. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  5. sqlite3.OperationalError: unable to open database file
  6. How to open and convert sqlite database to pandas dataframe
  7. Python sqlite3.OperationalError: no such table:
  8. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  9. Django: Deploying an application on Heroku with sqlite3 as the database
  10. How do you escape strings for SQLite table/column names in Python?
  11. How to load existing db file to memory in Python sqlite3?
  12. Sqlite insert query not working with python?
  13. Python SQLite parameter substitution with wildcards in LIKE
  14. Inserting a table name into a query gives sqlite3.OperationalError: near “?”: syntax error
  15. Python insert numpy array into sqlite3 database
  16. SQLAlchemy: cascade delete
  17. How to implement “autoincrement” on Google AppEngine
  18. Auto Increment on Composite Primary Key – Sqlite3 + Python
  19. Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
  20. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  21. How to upgrade sqlite 3.8.2 to >= 3.8.3
  22. creating a database outside the application context
  23. Getting random row through SQLAlchemy
  24. Select NULL Values in SQLAlchemy
  25. How to delete a table in SQLAlchemy?
  26. Python and SQLite: insert into table
  27. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  28. How to check the existence of a row in SQLite with Python?
  29. sqlite3.OperationalError: no such column – but I’m not asking for a column?
  30. Django: sudden DB reset after Heroku sleep

Leave a Comment