CREATE ROLE
  • References/Database/PostgreSQL/Commands

NameCREATE ROLE -- define a new database role Synopsis

2025-01-10 15:47:30
ALTER POLICY
  • References/Database/PostgreSQL/Commands

NameALTER POLICY -- change the definition of a row level security policy Synopsis

2025-01-10 15:47:30
DROP VIEW
  • References/Database/PostgreSQL/Commands

NameDROP VIEW -- remove a view Synopsis

2025-01-10 15:47:30
Catalogs: pg_available_extensions
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_available_extensions view lists the extensions that are available for installation. See also the

2025-01-10 15:47:30
btree_gist
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

btree_gist provides GiST index operator classes that implement B-tree equivalent behavior for the data types int2,

2025-01-10 15:47:30
fuzzystrmatch
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The fuzzystrmatch module provides several functions to determine similarities and distance between strings.

2025-01-10 15:47:30
Pattern Matching
  • References/Database/PostgreSQL/Functions and Operators

There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL

2025-01-10 15:47:30
Monitoring: Viewing Locks
  • References/Database/PostgreSQL/Monitoring

Another useful tool for monitoring database activity is the pg_locks system table. It allows the database administrator to view information

2025-01-10 15:47:30
JSON Functions and Operators
  • References/Database/PostgreSQL/Functions/JSON

Table 9-42 shows the operators that are available for use with the two JSON data types (see Section 8.14)

2025-01-10 15:47:30
SECURITY LABEL
  • References/Database/PostgreSQL/Commands

NameSECURITY LABEL -- define or change a security label applied to an object Synopsis

2025-01-10 15:47:30