Create view

sql

CREATE VIEW active_users AS
SELECT user_id, email
FROM public.users
WHERE deleted_at IS NULL;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Views, Functions, Triggers, and Extensions

Create a new database in the cluster.

Open In sheetsql1 tag match

Create a namespace for objects.

Open In sheetsql1 tag match

Create a database with explicit owner and template.

Open In sheetsql1 tag match

Create a basic table with primary key and defaults.

Open In sheetsql1 tag match

Use a SQL-standard identity column instead of serial.

Open In sheetsql1 tag match

Create a role that can log in.

Open In sheetsql1 tag match