Unified data infrastructure
GitHub Let's talk

Sequences and views

CREATE SEQUENCE, nextval/currval, serial columns, and views.

Version
Latest
v0.1.0 · latest 1 min read
On this page
  1. Sequences
  2. Views

Sequences#

sqlsource
CREATE SEQUENCE order_seq;
SELECT nextval('order_seq'), currval('order_seq');
CREATE TABLE t (id BIGINT DEFAULT nextval('order_seq') PRIMARY KEY);
-- serial shorthand creates <table>_<col>_seq automatically:
CREATE TABLE s (id SERIAL PRIMARY KEY, big BIGSERIAL, small SMALLSERIAL);

Sequence values dispatch through catalog_fn.rs:sequence_value (requires the join engine path, like generate_series).

Views#

sqlsource
CREATE [OR REPLACE] VIEW active_users [(id, name)] AS SELECT id, name FROM users WHERE status =
  'active';
DROP VIEW [IF EXISTS] active_users [CASCADE|RESTRICT];

Views are real (re-executed SELECT). MATERIALIZED VIEW parses to a stub without materialization; REFRESH parses to an empty-name stub.

Was this page helpful?
Next

Continue

Next: Indexes Why indexes exist, when to use them, what they serve, and how they work. Playground Run the documented statements against the sample dataset. Architecture The layers underneath the documented surface.