PopSQL

How to Create a View in PostgreSQL

create or replace view enriched_users as (
  select *
  from users
  inner join enrichments on enrichments.user_id = users.id
);
database icon
Finally, a unified workspace for your SQL development
Get more done, together, with PopSQL and PostgreSQL