select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

pg_nowhere

A PostgreSQL extension to disallow UPDATE and DELETE queries without a WHERE clause.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagepg_nowhere
Version0.1
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2026-01-03
Catalogue updated2026-08-30

Related extensions

See also

pg_strictPrevent dangerous UPDATE and DELETE without WHERE clause
pg_parapetHooks that can require WHERE on UPDATE and DELETE and restrict TRUNCATE to superusers.