O'Reilly logo

PostGIS Essentials by Angel Marquez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a spatial database using GUI

There are a lot of people who prefer to use the command line instead of a graphical GUI for interacting with the DBMS. If you are not one of them, you can make all these operations using the PGAdmin application. Now, we will create another database called Real-World that will store geographic features of the cities where the company have properties for sale:

  1. First, we will click the windows Start button and type pgadmin in the Search programs and files text box. After that, we will execute the PGAdmin III application.
  2. Once the main window is shown, we must double-click on the PostgreSQL 9.3 (localhost:5432) icon for opening the local server, as shown in the following screenshot:
  3. Once it's opened, we have to click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required