PostgreSQL Tutorial: Managing Views
Summary: In this tutorial, you will learn about views and how to manage views in PostgreSQL.
PostgreSQL Tutorial: Materialized Views
Summary: This tutorial introduces you to PostgreSQL materialized views that allow you to store the result of a query physically and update the data periodically.
PostgreSQL Tutorial: Recursive View
Summary: In this tutorial, you will learn how to create a PostgreSQL recursive view using the CREATE RECURSIVE VIEW statement.
PostgreSQL Tutorial: Updatable Views
Summary: In this tutorial, we will discuss the requirements for updatable views and show you how to create updatable views in PostgreSQL.
PostgreSQL Tutorial: Views
A view is a named query that provides another way to present data in the database tables. A view is defined based on one or more tables which are known as base tables. When you create a view, you basically create a query and assign a name to the query. Therefore, a view is useful for wrapping a commonly used complex query.
PostgreSQL Tutorial: ADD COLUMN: Add One Or More Columns To a Table
Summary: In this tutorial, you will learn how to use the PostgreSQL ADD COLUMN statement to add one or more columns to an existing table.
PostgreSQL Tutorial: ALTER TABLE
Summary: In this tutorial, you will learn how to use the PostgreSQL ALTER TABLE statement to modify the structure of a table.
PostgreSQL Tutorial: CREATE INDEX
Summary: In this tutorial, you will learn about indexes and how to use the PostgreSQL CREATE INDEX statement to define a new index for a table.
PostgreSQL Tutorial: CREATE TABLE AS
Summary: In this tutorial, you will learn how to use the PostgreSQL CREATE TABLE AS statement to create a new table from the result set of a query.
PostgreSQL Tutorial: DROP COLUMN: Remove One or More Columns of a Table
Summary: This tutorial shows you how to use the PostgreSQL DROP COLUMN clause in the ALTER TABLE statement to remove one or more columns of a table.