Create materialized view

sql

CREATE MATERIALIZED VIEW daily_sales AS
SELECT date_trunc('day', created_at) AS day, sum(total_amount) AS revenue
FROM orders
GROUP BY 1;

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