9.3.2
Table Of Contents
- Using VMware vFabric Postgres
- Contents
- Preface
- VMware Customizations for PostgreSQL
- Installing vFabric Postgres
- vFabric Postgres Client Tools and Libraries
- Managing vFabric Postgres
- Migrate PostgreSQL Data from Earlier Versions Into vFabric Postgres 9.3
- Migrate PostgreSQL Data Into vFabric Postgres
- Restarting the vFabric Postgres Service
- Connection to a vFabric Postgres Database
- Accounts and Services
- Safeguarding Data
- About vFabric Postgres Replication
- Create a Replication User Account
- Create a Replica Server
- Promote a Replica Database to Primary Database
- Monitoring Replication Status
- Using Perl and Python Language Extensions
- Viewing Performance Statistics
- Troubleshooting Guidelines
- Using the Graphical User Interface
- Index
6 (Optional) In Constraints, select the type of constraint, Foreign key, Unique, or Check, that applies to
the new column.
You can create foreign key constraints only if the schema has more than one table.
a Click Create.
b Enter the conditions for the constraint, and click OK.
c Click Next to continue, or click Finish to create the table.
7 (Optional) In the Auto Vacuum Settings, select settings for removing stale data from your table,
The default settings work well for most environments. For information about autovacuum, see the
documentation on the Postgres.org site.
8 Click Finish to create 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.
Prerequisites
Verify that the table on which you want to create the view exists.
Procedure
1 In the left pane, click the Schemas arrow to expand it.
2 Right-click the schema and select Create > View.
3 Enter the view properties.
a Type a unique name in the Name text box.
If the name is case-sensitive, select the Case sensitive check box.
b (Optional) To restrict who can modify the view, select an owner for the view definition from the
drop-down menu.
c Enter a SQL query to define the view.
For example, if you are creating a view of your office_locations table named China Offices, you
might enter a query similar to the following to select all the office locations in China.
select office_name, addr1, addr2, addr3 from office_locations where country="China"
4 Click OK.
The view appears in the left pane under the Views icon.
What to do next
Examine the data in the view. See “Examine View Data,” on page 43.
Examine View Data
A view is a subset of related table data. After you create a view, you can examine the data in the view.
Prerequisites
Verify that a view is available.
Chapter 5 Using the Graphical User Interface
VMware, Inc. 43