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
SQL editing that just rocks
PopSQL and PostgreSQL, better together