select open change scope Open full search

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

Extensions / Time series

pg_task

execute any sql command at any specific time at background

pgext.cloud · Source code · License text · PGXN

Overview

Packagepg_task
Version3.0.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeNo DDL
Requires CREATE EXTENSIONNo
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_task
Stars68
Latest commit2026-08-03
Latest release2026-08-03
Catalogue updated2026-09-19

Related extensions

See also

pg_cronJob scheduler for PostgreSQL
pg_durableSQL-native durable orchestrations for PostgreSQL
pg_backgroundRun SQL queries in the background
pgagentA PostgreSQL job scheduler
pg_dispatchAsynchronous SQL dispatcher built on pg_cron
pg_dbms_jobExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL
pg_laterRun queries now and get results later
pgmqA lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
ulakTransactional Outbox extension for PostgreSQL with reliable asynchronous delivery
pg_retryRetry SQL statements on transient errors with exponential backoff