My mobile phone is rooted, so I was able to copy
/data/data/com.android.providers.contacts/databases/contacts2.db
to my SD card and from there to my computer. However, using e.g. sqliteman SQLite Browser on Windows gives me an error when I try to open this database, claiming that it probably isn't one. Also tried SQLitebrowser on Windows. What's the problem / how to view the database?
Note: I got the database from an android 2.3 phone.
Update: I don't really know why, but it worked after copying the sqlite db to ubuntu and use sqliteman over there.