CREATE MATERIALIZED VIEW

px shi <spxlyy123@gmail.com>

From: px shi <spxlyy123@gmail.com>
To: pgsql-hackers@postgresql.org
Date: 2024-07-25T11:48:01Z
Lists: pgsql-hackers
Hi, I see that materialized view cannot be unlogged now, but when I use
psql and type CREATE UNLOGGED, pressing the Tab key for auto-completion
suggests `TABLE` and MATERIALIZED VIEW.
Shouldn't `MATERIALIZED VIEW ` be suggested?

Commits

  1. Remove tab completion for CREATE UNLOGGED MATERIALIZED VIEW.

  2. Add tab completion for CREATE SCHEMA in psql

  3. Disallow unlogged materialized views.

  4. Add a materialized view relations.