BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

219PostgreSQL text versus varchar
220char padding semantics
221length for character counts
222char_length and character_length
223octet_length for encoded bytes
224bit_length for bit counts
225lower case conversion
226upper case conversion
227initcap word capitalization
228ascii code extraction
229chr character construction
230Unicode code points versus grapheme clusters
231Server encoding and client_encoding
232convert between character sets
233convert_to encoded bytea
234convert_from decoded text
235normalize Unicode normalization
236IS NORMALIZED predicates
237Collation-sensitive text comparison
238Nondeterministic ICU collations
239substring by position and length
240substring with SQL regex patterns
241substr positional extraction
242left leading characters
243right trailing characters
244position substring search
245strpos substring offsets
246overlay substring replacement
247replace literal substitutions
248translate character mapping
249trim both ends
250btrim custom character trimming
251ltrim leading character trimming
252rtrim trailing character trimming
253lpad left padding
254rpad right padding
255repeat string repetition
256reverse character order
257concat heterogeneous values
258concat_ws separator-aware concatenation
259format positional formatting
260format %I identifier quoting
261format %L literal quoting
262quote_ident identifiers
263quote_literal literals
264quote_nullable nullable literals
265split_part field extraction
266string_to_array tokenization
267string_to_table token rows
268array_to_string text assembly
269regexp_like boolean matching
270regexp_match first capture set
271regexp_matches multiple capture sets
272regexp_replace substitutions
273regexp_split_to_array token arrays
274regexp_split_to_table token rows
275regexp_count occurrence counts
276regexp_instr match positions
277regexp_substr matched substrings
278Regex anchors and boundaries
279Regex character classes and quantifiers
280Regex capturing and noncapturing groups
281Regex flags and greedy matching
282bytea hexadecimal input
283bytea escape format
284encode hexadecimal and base64 output
285decode binary input
286bytea get_byte
287bytea set_byte
288bytea get_bit
289bytea set_bit
290md5 text checksums
291sha224 and sha256 binary digests
292sha384 and sha512 binary digests
293Extracting domains from help-desk email addresses
294Normalizing phone numbers in a contacts dataset

Databases & SQL

219PostgreSQL text versus varchar
220char padding semantics
221length for character counts
222char_length and character_length
223octet_length for encoded bytes
224bit_length for bit counts
225lower case conversion
226upper case conversion
227initcap word capitalization
228ascii code extraction
229chr character construction
230Unicode code points versus grapheme clusters
231Server encoding and client_encoding
232convert between character sets
233convert_to encoded bytea
234convert_from decoded text
235normalize Unicode normalization
236IS NORMALIZED predicates
237Collation-sensitive text comparison
238Nondeterministic ICU collations
239substring by position and length
240substring with SQL regex patterns
241substr positional extraction
242left leading characters
243right trailing characters
244position substring search
245strpos substring offsets
246overlay substring replacement
247replace literal substitutions
248translate character mapping
249trim both ends
250btrim custom character trimming
251ltrim leading character trimming
252rtrim trailing character trimming
253lpad left padding
254rpad right padding
255repeat string repetition
256reverse character order
257concat heterogeneous values
258concat_ws separator-aware concatenation
259format positional formatting
260format %I identifier quoting
261format %L literal quoting
262quote_ident identifiers
263quote_literal literals
264quote_nullable nullable literals
265split_part field extraction
266string_to_array tokenization
267string_to_table token rows
268array_to_string text assembly
269regexp_like boolean matching
270regexp_match first capture set
271regexp_matches multiple capture sets
272regexp_replace substitutions
273regexp_split_to_array token arrays
274regexp_split_to_table token rows
275regexp_count occurrence counts
276regexp_instr match positions
277regexp_substr matched substrings
278Regex anchors and boundaries
279Regex character classes and quantifiers
280Regex capturing and noncapturing groups
281Regex flags and greedy matching
282bytea hexadecimal input
283bytea escape format
284encode hexadecimal and base64 output
285decode binary input
286bytea get_byte
287bytea set_byte
288bytea get_bit
289bytea set_bit
290md5 text checksums
291sha224 and sha256 binary digests
292sha384 and sha512 binary digests
293Extracting domains from help-desk email addresses
294Normalizing phone numbers in a contacts dataset

← Databases & SQL

Search the Databases & SQL glossary

Lesson 261 of 2,478·5. Text and Binary FunctionsFree lesson

format %L literal quoting

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy