Getting Started - Mac

This tutorial will help you get up and running querying the Canadian Intellectual Property Office (CIPO) Patent PostgreSQL Database. It will cover accessing the high performance computing environment, querying the database via SQL statements and from within a python script, and downloading the results of the query.

You will need a Compute Canada account with the proper credentials to access this database. If you haven’t done so already, you should first follow the instructions to get your account set up.

Note: This tutorial is intended for Mac users. If you are using Windows, check out this tutorial instead.

Technique: Searching for maps and data, Text and Data Mining | Tools: CIPO


First created: November 30, 2022
Last updated: August 05, 2026

Tutorial maintained by Leslie Barnes.

Tutorial created by Kara Handren.

Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International icon