Geography Reference
In-Depth Information
much easier and quicker to use the GUI. Please also note that even if you are installing your
database on a platform such as Ubuntu, the pgAdmin tool can be downloaded separately
from the Postgres website and installed on a standard Windows machine for managing your
server.
Once the database has been created, you can expand the objects in the server tree to show
the different tables and objects in your new spatial database.
Figure 15: Exploring the New Database
A Side Note about Postgres Users
Many of you reading this will likely be accustomed to using MS SQL Server for your data
tasks. Postgres, like SQL Server, supports multiple user accounts. However, you need to be
careful with using the root admin account.
In MS SQL, the super user account (usually
sa
) has ultimate control over the entire
database. Under Postgres, the equivalent super user account is called
Postgres
, but unlike
MS SQL, the Postgres user can be prevented from interacting with other tables.
If you create all your tables using the Postgres account you won't have an issue, but if you
create databases and then assign ownership of these databases to other user names you
have created in your server, you might find that the
Postgres
user account is unable to work
with them.
