↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

overlay

Replaces the substring of string that starts at the start'th character and extends for count characters with newsubstring. If count is omitted, it defaults to the length of newsubstring.

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.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920
group
string
group label
字符串函数和操作符
lang
en
layout
table-new
pages
functions-string.html, functions-binarystring.html, functions-bitstring.html
prose only
false

Definition PG 18

Replaces the substring of string that starts at the start'th character and extends for count characters with newsubstring. If count is omitted, it defaults to the length of newsubstring.

Signatures and overloads

overlay ( string text PLACING newsubstring text FROM start integer [FOR count integer] ) → text → text
Replaces the substring of string that starts at the start'th character and extends for count characters with newsubstring. If count is omitted, it defaults to the length of newsubstring.
overlay ( bytes bytea PLACING newsubstring bytea FROM start integer [FOR count integer] ) → bytea → bytea
Replaces the substring of bytes that starts at the start'th byte and extends for count bytes with newsubstring. If count is omitted, it defaults to the length of newsubstring.
overlay ( bits bit PLACING newsubstring bit FROM start integer [FOR count integer] ) → bit → bit
Replaces the substring of bits that starts at the start'th bit and extends for count bits with newsubstring. If count is omitted, it defaults to the length of newsubstring.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-binarystring.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"cd434063935e362cbb3621171770936b04bafcd58673d71a20cd6992580b2d84","version":"18.7"},{"file":"functions-bitstring.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"270c5c14b6fe519e8d8cc3f7514e0202aa8d534d1e9c8f62ab1ad6802faaa531","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","version":"18.7"},{"file":"functions-binarystring.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"a5ee5be3c79e45371853d5c6dd8b1b3f52734bbc17726dbe626837179a1da1e0","version":"18.7"},{"file":"functions-bitstring.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"6b6423f8b2751016eae606a5cdcf7062bd62f230a0ef96b83e357418208bc67e","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

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:68147e0c015d3413f62ca81c9811db79a786e19975ba77ae0af88569467b0e21

Text language: en · wiki-repair-20261023:68147e0c015d3413f62ca81c9811db79a786e19975ba77ae0af88569467b0e21