| Extension name |
pg_auto_mv (hyphenated, per pg_auto_mv.control) |
| Schema |
pgauto_mv (no hyphen — PostgreSQL 16+ blocks pg_-prefixed schemas) |
| Channel names |
pg_auto_mv.{verb} (extension name prefix) |
auto_mv_id |
uuid, always gen_random_uuid() or a caller-supplied UUID |
| Generated function |
pgauto_mv._trig_{id_safe}_{schema_safe}_{table_safe}() |
| Generated DML trigger |
pg_auto_mv_{id_safe} on watch table |
| Generated TRUNCATE trigger |
pg_auto_mv_{id_safe}_trunc on watch table |
| UUID-safe form |
replace(auto_mv_id::text, '-', '_') — applied everywhere in generated names |