|
|
Quickly extract all email addresses from Address Book
Does anyone know how to find the column names in any of the Addressbook or Calendar files?
Quickly extract all email addresses from Address Book
The sqlite3 command .tables will show a list of tables, and .schema TABLENAME will show the SQL CREATE statement for that table. e.g.
sqlite3 ~/Library/Application\ddressBook/AddressBook-v22.abcddb '.schema ZABCDEMAILADDRESS' CREATE TABLE ZABCDEMAILADDRESS ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, Z_OPT INTEGER, ZORDERINGINDEX INTEGER, ZISPRIMARY INTEGER, ZOWNER INTEGER, Z19_OWNER INTEGER, ZISPRIVATE INTEGER, ZADDRESS VARCHAR, ZADDRESSNORMALIZED VARCHAR, ZUNIQUEID VARCHAR, ZLABEL VARCHAR ); CREATE INDEX ZABCDEMAILADDRESS_ZADDRESSNORMALIZED_INDEX ON ZABCDEMAILADDRESS (ZADDRESSNORMALIZED); CREATE INDEX ZABCDEMAILADDRESS_ZADDRESS_INDEX ON ZABCDEMAILADDRESS (ZADDRESS); CREATE INDEX ZABCDEMAILADDRESS_ZOWNER_INDEX ON ZABCDEMAILADDRESS (ZOWNER); Edited on Feb 01, '10 06:16:56AM by robg
|
SearchFrom our Sponsor...Latest Mountain Lion HintsWhat's New:HintsNo new hintsComments last 2 daysLinks last 2 weeksNo recent new linksWhat's New in the Forums?
Hints by TopicNews from Macworld
From Our Sponsors |
|
Copyright © 2014 IDG Consumer & SMB (Privacy Policy) Contact Us All trademarks and copyrights on this page are owned by their respective owners. |
Visit other IDG sites: |
|
|
|
Created this page in 0.07 seconds |
|