Sign up for Hasura Newsletter

Create View

In this example, we will look at how to create a PostgreSQL view with CREATE OR REPLACE VIEW statement.

Create a PostgreSQL View

You can create a Postgres view with CREATE OR REPLACE VIEW statement. For example, to create a view for the existing users table to find only users who are above a particular age. We can make use of SELECT to get exactly the type of data and rows we want in the view to be able to dynamically query.

CREATE OR REPLACE VIEW "public"."old_users" AS
SELECT users.id,
users.age
FROM users
WHERE (users.age >= 60);
Did you find this page helpful?
Start with GraphQL on Hasura for Free
  • ArrowBuild apps and APIs 10x faster
  • ArrowBuilt-in authorization and caching
  • Arrow8x more performant than hand-rolled APIs
Promo
footer illustration
Brand logo
© 2021 Hasura Inc. All rights reserved
Github
Titter
Discord
Facebook
Instagram
Youtube
Linkedin