Database Reference
In-Depth Information
Figure 4-5. Installing extensions using pgAdmin
Creating Database Assets and Setting Privileges
pgAdmin lets you create all kinds of database assets and assign privileges.
Creating databases and other database assets
Creating a new database in pgAdmin is easy. Just right-click the database section of the
tree and choose New Database, as shown in
Figure 4-6
. The definition tab provides a
drop-down menu for you to select a template database, similar to what we did in
“Tem‐
plate Databases” on page 27
.
Figure 4-6. Creating a new database
Follow the same steps to create roles, schemas, and other objects. Each will have its own
relevant set of tabs for you to specify additional attributes.
Privilege management
To manage privileges of database assets, nothing beats the pgAdmin Grant Wizard,
which you access from the Tools→Grant Wizard menu of pgAdmin. As with many other
