Page History

PGadmin basics

After successful installation of PostgreSQL and optional the PostgreSQL geospatial extension you can start using the database.
On windows PostgreSQL comes with the PGadmin III database manager.

Image Modified

You always need to log-in for accessing your database. Store your log-in credentials well.

Image Modified
Image Modified

By default the database instances inside the PostgreSQL server are not listed as active. Only when you click on them, the contents of the database can be folded like in a file explorer. The postgres database is present by default, the template_postgis_20 database was added when installing PostGIS,
and the sandbox database was added optionally by when installing PostGIS.

Image Removed
Image Removed
Image Removed

We are now opening the postgres database. When unfolding it, Catalogs, Extensions and Schemas appear.

. PostGIS extension is only available when activated. You need to activate every time you create a new database.

Image Added

Give it a proper name.
Unfold it using the + signs. You find a completely clean database.

Image Added

Next step is to add the PostGIS extension and its funtions to the newly created database. Navigate to tables and press the button Image Added SQL.
This opens the SQL window to write queries.
Type and execute (by pressing the green buttonImage Added) the following create queries.

create extension postgis

create extension postgis_topology

Now your database is ready to insert some data. Proceed with the Step by step approach.Image Removed