How to fix `error: type "geometry" does not exist`

postgis-geometry-error.md

How to fix error: type "geometry" does not exist

The error Error: type "geometry" does not exist is sometimes encountered whilst working with Postgres databases.

You can easily fix this by following the following steps:

1. Update your database search path.

     ALTER DATABASE <your database name> SET search_path=public,postgis;
   

   N.B: Ensure you replace <your database name> in the query above with your actual database name.

2. Disconnect and reconnect to your database, as you the change above will not take effect in the same session.

3. Install required extensions.

     CREATE EXTENSION fuzzystrmatch;
     CREATE EXTENSION postgis_tiger_geocoder;