Search⌘ K
AI Features
Home
Courses
The Art of PostgreSQL

Challenge: Creating a View

Explore how to create a view in PostgreSQL to provide user access to data without altering the original records. Learn to write the create view statement, query the view, and understand how views help in managing data safely and efficiently.

We'll cover the following...

Problem statement

There is a customer table in the f1db database. We need to allow the user to access and update the data, but we don’t want the changes to affect the original data. We need to create a view for this purpose. Please perform the following two tasks in order to complete this challenge:

Task

...