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: Array Data Type
Summary: in this tutorial, we will show you how to work with PostgreSQL array and introduce you to some handy functions for array manipulation.
PostgreSQL Tutorial: Boolean Data Type
Summary: in this tutorial, you will learn about the PostgreSQL Boolean data type and how to use it in designing the database tables.
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: Date Data Type
Summary: this tutorial discusses PostgreSQL DATE data type and shows you how to use some handy date functions to handle dates values.
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.
PostgreSQL Tutorial: DROP INDEX
Summary: In this tutorial, you will learn how to use the PostgreSQL DROP INDEX statement to remove an existing index.
PostgreSQL Tutorial: DROP TABLE
Summary: In this tutorial, you will learn how to use the PostgreSQL DROP TABLE statement to remove existing tables from the database.
PostgreSQL Tutorial: hstore Data Type
Summary: in this tutorial, you’ll learn how to work with PostgreSQL hstore data type.