Skip to content

masterclass Buddy

Sign in Start learning

API reference

PostgreSQL API reference

SQL, indexes, JSON and replication

Last updated 1 November 2026

Identifiers: 84
With full guides: 0
Types: 4

Topics covered

Queries
Indexes
JSON
Transactions
Performance
Replication

Function

Name	What it does
`now`	Function
`coalesce`	Function
`nullif`	Function
`jsonb_build_object`	Function
`jsonb_agg`	Function
`json_agg`	Function
`array_agg`	Function
`string_agg`	Function
`to_tsvector`	Function
`to_tsquery`	Function
`row_number`	Function
`rank`	Function
`dense_rank`	Function
`lag`	Function
`lead`	Function
`generate_series`	Function
`date_trunc`	Function
`extract`	Function
`gen_random_uuid`	Function
`unnest`	Function
`regexp_replace`	Function

Type Alias

Name	What it does
`jsonb`	Type Alias
`uuid`	Type Alias
`timestamptz`	Type Alias
`text`	Type Alias
`numeric`	Type Alias
`bytea`	Type Alias
`tsvector`	Type Alias
`int4range`	Type Alias
`ENUM`	Type Alias

Command

Name	What it does
`SELECT`	Command
`INSERT`	Command
`UPDATE`	Command
`DELETE`	Command
`MERGE`	Command
`CREATE TABLE`	Command
`ALTER TABLE`	Command
`DROP TABLE`	Command
`CREATE INDEX`	Command
`CREATE VIEW`	Command
`CREATE MATERIALIZED VIEW`	Command
`REFRESH MATERIALIZED VIEW`	Command
`CREATE FUNCTION`	Command
`CREATE TRIGGER`	Command
`CREATE EXTENSION`	Command
`BEGIN`	Command
`COMMIT`	Command
`ROLLBACK`	Command
`SAVEPOINT`	Command
`VACUUM`	Command
`ANALYZE`	Command
`EXPLAIN`	Command
`EXPLAIN ANALYZE`	Command
`COPY`	Command
`GRANT`	Command
`REVOKE`	Command
`TRUNCATE`	Command
`LISTEN`	Command
`NOTIFY`	Command
`WITH`	Command
`ON CONFLICT`	Command
`RETURNING`	Command
`LATERAL`	Command
`psql`	Command
`pg_dump`	Command
`pg_restore`	Command

Concept

Name	What it does
`MVCC`	Concept
`Write-ahead log`	Concept
`B-tree index`	Concept
`GIN index`	Concept
`GiST index`	Concept
`BRIN index`	Concept
`Partial index`	Concept
`Covering index`	Concept
`Table partitioning`	Concept
`Streaming replication`	Concept
`Logical replication`	Concept
`Isolation levels`	Concept
`Row-level security`	Concept
`Connection pooling`	Concept
`Deadlocks`	Concept
`Autovacuum`	Concept
`pgvector`	Concept
`Query planner`	Concept

Search across every package and filter by type in your dashboard.