Knowledge Base Detail

Category Name > MacOsX
Read Apple Notes via terminal
  1. sqlite3 ~/Library/Containers/com.apple.Notes/Data/Library/Notes/NotesV7.storedata
  2. .mode csv
  3. .headers on
  4. .output ‘| open -f’
  5. select f.ZNAME AS Folder, n.ZTITLE AS Title, b.ZHTMLSTRING AS NoteHTML

    from ZNOTE n

    inner join ZFOLDER f ON n.ZFOLDER = f.Z_PK

    inner join ZNOTEBODY b ON n.ZBODY = b.Z_PK;

  6. .exit
Article Attachment