Getting Started with the Canadian Intellectual Property Office (CIPO) Patent PostgreSQL Database - Windows

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 Windows users. If you are using a Mac, check out this tutorial instead.

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


First created: January 05, 2023
Last updated: June 26, 2026

Tutorial maintained by Leslie Barnes.

Tutorial created by Kara Handren.

Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International icon