Read Microsoft PST files with rich schemas for common MAPI types (emails, contacts, appointments, tasks)
Maintainer(s):
mach-kernel
Installing and Loading
INSTALL pst FROM community;
LOAD pst;
Example
-- Count all messages in PST files
SELECT count(*) FROM read_pst_messages('*.pst');
-- Query contacts from a PST file (supports remote URIs)
SELECT given_name, surname, business_telephone, email_address
FROM read_pst_contacts('outlook.pst')
LIMIT 10;
-- Read messages with limit (applied during planning for large files)
SELECT subject, sender_email_address, message_delivery_time
FROM read_pst_messages('*.pst', read_limit=100);
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| read_pst_appointments | table | NULL | NULL | |
| read_pst_contacts | table | NULL | NULL | |
| read_pst_distribution_lists | table | NULL | NULL | |
| read_pst_folders | table | NULL | NULL | |
| read_pst_messages | table | NULL | NULL | |
| read_pst_notes | table | NULL | NULL | |
| read_pst_sticky_notes | table | NULL | NULL | |
| read_pst_tasks | table | NULL | NULL |