Catalog Objects

Reference: Catalog Objects

CedarDB supports the standard set of PostgreSQL database objects. Each page covers all operations on that object type: creating, altering, and dropping.

  • DatabasesCREATE, ALTER, DROP DATABASE
  • FunctionsCREATE, ALTER, DROP FUNCTION/PROCEDURE, DO, CALL
  • IndexesCREATE, DROP INDEX, index types, partial and expression indexes
  • PoliciesCREATE, ALTER, DROP POLICY, row level security
  • RolesCREATE, ALTER, DROP ROLE, GRANT, REVOKE
  • SchemasCREATE, ALTER, DROP SCHEMA, search_path
  • TablesCREATE, ALTER, DROP TABLE, constraints, partitioning
  • ViewsCREATE, DROP VIEW, materialized views, REFRESH