Create a new PostgreSQL view
CREATE VIEW viewname AS SELECT column1, column2, ... FROM tablename;
Create view for active users
CREATE VIEW active_users AS SELECT * FROM users WHERE status = 'active';