Geography Reference
In-Depth Information
Figure 13: Choosing a Template from the Definition Tab
All the other options in this tab can be left as they are. Once you click
OK
, pgAdmin will
return to the main display where you'll see your new database appear in the server tree.
Figure 14: New Database Added to Server Tree
It's also possible to create the database by hand using standard SQL commands such as
Create Database
and
Create Table
; however, using these can be a lengthy process.
There are scripts in the Postgres
Contrib
directory (located where you chose to install
Postgres) that you can load and run to create all the spatial functions and metadata tables
required. Since every installation of Postgres I've done has included pgAdmin, I've found it
