Managing PostgreSQL Database under Domain Owner

As a domain owner, you can manage the existing PostgreSQL databases created by the admin: add tables, fields, back up database and etc.

To be able to manage PostgreSQL databases, you have to be logged in as CP+ domain admin. Once you are there, do the following:

1. On the Home page, cilck the PostgreSQL Management icon in the Account Features section. You will see the page with existing databases:
   

   

2. Click the database name to get access to tables.
3. To add more tables to this database, click Create a new table. The following page will show:



4. Fill the table creation form:
   • Enter Table name;
   • Set Initial fields: enter field names, choose data type, set type width and field options, if necessary.
5. Click Create.

To manage a specific table:

• Click the field name to modify field parameters. You can change field name, data type, type width. Make sure to click Save to preserve changes.
• Add more fields by choosing the data type from the drop-down box. Fill the form that shows and click Create.
• Click the View Data button to see the data entered into the table. Here you can edit selected rows, add/delete rows.
• Click the Drop Table button to delete table .

To manage database:

• You can back up database by clicking the Backup button on the databases page.



Fill the form and click Backup now if you want to do it immediately.

• You can restore backed up database by clicking the Restore button on the databases page.
• You can enter SQL command that can be executed on particular database by clicking Execute SQL.