How to Create a Spatial Database With PostgreSQL and pgAdmin 4 on Windows 11 | Complete Guide | PostGIS | 2024

EBISYS Tech
0

 

Introduction

Prerequisites

Step 1: Getting Started with pgAdmin

Step 2: Creating a New Database

Step 3: Creating a Login Role

Step 4: Granting Privileges

grant all privileges on database cptwater to waterwatch;

Step 5: Adding Spatial Extensions

create extension postgis;
create extension postgis_topology;

Conclusion

Post a Comment

0Comments
Post a Comment (0)