- Cisco Sensitive Routing User Guide

2-18
Cisco Carrier Sensitive Routing User Guide
Chapter2 PostgreSQL Database Operations and Functionalities
Database Functionalities
Note Tables IngressRoutes_1, IngressRoutes_2, EgressRoutes_1, and EgressRoutes_2 can inherit
from this QoS table.
PostgreSQL Database Command Summary
Following is a summary of frequently used postgreSQL commands. Refer to the online manual pages
and help section for more information.
• createdb—Creates a new database in postgreSQL. A database name is required when using this
command.
• createuser—Creates a postgreSQL user. A user name is required when using this command.
• dropdb—Removes a database from postgreSQL. A database name is required when using this
command.
• dropuser—Removes a postgreSQL user. A user name is required when using this command.
• initdb—Creates a new postgreSQL database installation. This command is used only once when the
database is installed. It creates the base directory. This command cannot be used again.
• psql—SQL interface to the postgreSQL databases. A database name is required when using this
command.
• vacuumdb—Cleans and analyzes a postgreSQL database.