Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostgreSQL INSERT, UPDATE, and DELETE Commands

Introduction
4. The product table
INSERT with SELECT
Referring to other tables
INSERT, UPDATE, and DELETE with subqueries
Summary

Instruction

The product table describes the products we sell.

Exercise

Select all columns from the product table. It contains:

  • id – Uniquely identifies each product type in our warehouse.
  • name – The name of the product.
  • price – The price for one unit of that product.
  • delivered_timestamp – When the product was delivered to our warehouse.
  • price_timestamp – The date of the most recent price change for that product.