References
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.

  • Databases — CREATE, ALTER, DROP DATABASE
  • Functions — CREATE, ALTER, DROP FUNCTION/PROCEDURE, DO, CALL
  • Indexes — CREATE, DROP INDEX, index types, partial and expression indexes
  • Materialized Views — CREATE, ALTER, DROP MATERIALIZED VIEW, REFRESH
  • Policies — CREATE, ALTER, DROP POLICY, row level security
  • Roles — CREATE, ALTER, DROP ROLE, GRANT, REVOKE
  • Schemas — CREATE, ALTER, DROP SCHEMA, search_path
  • Sequences — CREATE, ALTER, DROP SEQUENCE, nextval, setval
  • Tables — CREATE, ALTER, DROP TABLE, constraints, partitioning
  • Types — CREATE, ALTER, DROP TYPE for user-defined enum types
  • Views — CREATE, DROP VIEW