1.0
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director
- Updated Information
- VMware vFabric Data Director and vFabric Postgres Overview
- Managing Data Director Resources
- Managing Users and Roles
- Managing Organizations
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Monitoring the Data Director Environment
- Managing Licenses
- Reconfiguring Data Director Networks
- Change the vCenter IP Address
- Reconfigure the Web Console Network Mapping or Network Adapter
- Reconfigure the vCenter Network Mapping
- Reconfigure the vCenter Network Adapter Settings
- Reconfigure the DB Name Service Network or DB Name Service Network Adapter
- Reconfigure the Internal Network or Internal Network Adapter Mapping
- Verify Network Settings in Data Director
- Data Director Troubleshooting
- Index
5 You can now configure columns or exit the wizard.
n
Click Next to configure columns.
n
Click Finish to create the table.
6 (Optional) In the Columns tab, click Add to add a column, and complete the column fields.
a Type the column name.
b Select the column type.
Depending on the column type, you can specify a length or precision, and you can specify a default
value for the column.
c If users must enter a value for the column, select the Not Null check box.
d If the column is a primary key, select the Primary Keycheck box.
e Click Next to continue, or click Finish to create the column.
7 (Optional) In the Constraints tab, specify constraints that apply to the new column.
a Use the drop-down menu to select the type of constraint: Foreign key, Unique, or Check.
You can create foreign key constraints only if the schema has more than one table.
b Click Create to specify the constraint.
c Enter the conditions for the constraint, and click OK.
Data Director creates the constraint.
d Click Next to continue, or click Finish to create the column.
8 (Optional) In the Auto Vacuum Settings tab, specify settings for removing stale data from your table,
The default settings work well for most environments. For information about auto vacuum, see the
documentation on the Postgres.org site.
9 Click Finish to finish table creation.
Data Director creates the table.
Create a View
A view is a subset of related table data. For example, if you have a table that contains the locations of all
corporate offices throughout the world, you can create a view of all the offices in Europe, in California, or
Brazil. You create views from the Views tab in the schema pane.
Prerequisites
Verify that the table on which to create the view exists.
Procedure
1 Log in to Data Director as an organization administrator or user with database privileges and select a
database.
2 Click the Views tab.
3 Click the plus icon to create a view.
VMware vFabric Data Director Administrator and User Guide
68 VMware, Inc.