To figure out which column of your table that you want to look at to just see the email addresses, use the following command at the sqlite3 interactive prompt (noting that it’s case sensitive): Notice that here you’ll see email addresses, but also a lot more information. If you type the following then you’ll list all of the contents of the ZABCDEMAILADDRESS table: You can view the contents of this table using the following command: The basic information about a contact is stored in the ZABCDRECORD table. ![]() Once in the environment you can view databases, manually work with the data, etc. Sqlite3 ~/Library/Application Support/AddressBook/AddressBook-v22.abcddb For example, the following command will simply dump you into a sqlite interactive command line environment: In order to interfaces with Address Book.app you can use the sqlite3 command followed by the path to the database itself. The actual database is located in each users Library/Application Support/AddressBook directory and called AddressBook-v22.abcddb. ![]() The Mac OS X program, Address Book uses sqlite3 to store information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |