replace

Replaces all occurrences in string of substring from with substring to.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: string
group label: 字符串函数和操作符
lang: en
layout: table-new
pages: functions-string.html
prose only: false

Definition PG 18

Replaces all occurrences in string of substring from with substring to.

Signatures and overloads

replace ( string text, from text, to text ) → text → text

Replaces all occurrences in string of substring from with substring to.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7eecd3bb343149124be0476a539f3c682476eab2a15489a0e0ad06fbb769ea9e","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:004e02640c69616471921f7544dcb69fad656f71d5def3f9d5ff833d382f7ee5

Text language: en · wiki-repair-20261023:004e02640c69616471921f7544dcb69fad656f71d5def3f9d5ff833d382f7ee5