Accessing the vCenter Operations Capacity IQ database

To connect to the Capacity IQ database:

1. SSH to the UI VM.
2. Switch to the postgres user using the command: su - postgres
3. Connect to the database using the command: psql cmapp
4. To list all tables, type \\d at the cmapp=# prompt.
5. For hep with SQL commands type \\h  at the cmapp=# prompt.
6. For help with PSQL commands type \\?  at the cmapp=# prompt.