Skip to content

Welcome to the pgOperations Python module documentation

This site contains the project documentation for the Python PgOperations module. It is a simple lightweight Python module to perform the most common operations in PostgreSQL and PostgGIS, avoiding most of the SQL syntax.

The class methods allow insert, delete, update, select, create and delete tables and databases. Also, you will be able to know is a table exists, get the field names of a table, and manage counters for your applications. It does not avoid the need for SQL knowledge, but facilitates the most common tasks. Maybe it is suitable for beginners and small projects.

This module requires Python 3 and Psycopg2, and supposes all python dictionary keys match with the table field names.

Author Gaspar Mora-Navarro. Universitat Politècnica de València , Spain. Department of Cartographic Engineering Geodesy and Photogrammetry. Higher Technical School of Geodetic, Cartographic and Topographical Engineering.

Table Of Contents

Read the documentation to know how to use pgOperations. In the tutorial you will find out how to install and use the class methods, with examples. The reference contains the classes, methods, and parameters description:

  1. Tutorials
  2. Reference
  3. Explanation