Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Quickly extract all email addresses from Address Book' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Quickly extract all email addresses from Address Book
Authored by: S Barman on Aug 29, '08 09:04:58PM

Does anyone know how to find the column names in any of the Addressbook or Calendar files?



[ Reply to This | # ]
Quickly extract all email addresses from Address Book
Authored by: popguru on Aug 30, '08 04:23:53PM
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'
...returns...
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


[ Reply to This | # ]