Similar Topics

Web Technologies32.1K+ articles

DSA20.6K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.5K+ articles

School Learning11.1K+ articles

Databases1.9K+ articles

PostgreSQL386+ articles

ASCII153+ articles

PostgreSQL-function47+ articles

PostgreSQL-String-function

16 posts

PostgreSQL - Substring Function

Last Updated: 15 July 2025

PostgreSQLis a powerful relational database management system with extensive text processing functions, including the flexibleSUBSTRINGfunction. This function enables user...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - SPLIT_PART Function

Last Updated: 15 July 2025

The PostgreSQL SPLIT_PART() function is a powerful tool for splitting strings based on a specific delimiter, returning a specified part of the string. This function is par...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - RIGHT Function

Last Updated: 15 July 2025

The PostgreSQL RIGHT() function, allows you to extract a specified number of characters from the right side of a string. This function can be incredibly useful for various...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - REPLACE() Function

Last Updated: 04 August 2026

REPLACE() function in PostgreSQL replaces all occurrences of a specified substring within a string with another substring.Replace specific text within a string.Modify text...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - REGEXP_MATCHES Function

Last Updated: 15 July 2025

The PostgreSQL REGEXP_MATCHES() function is a powerful tool for matching POSIX regular expressions against a string. It returns substrings that satisfy the pattern, making...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - POSITION Function

Last Updated: 15 July 2025

The PostgreSQL POSITION() function is used to find the location of a substring within a string. This function is particularly useful for text manipulation and searching op...read more

article_image

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - MD5() Function

Last Updated: 15 July 2025

The PostgreSQL MD5() function is a useful tool for evaluating the MD5 hash of a given string and returning the result in hexadecimal form. This function is often used for ...read more

PostgreSQL-String-function

PostgreSQL - TRIM Function

Last Updated: 15 July 2025

The TRIM() function in PostgreSQL is an essential tool for removing unwanted characters from strings. Whether we're working with user inputs, formatting text, or performin...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL- LPAD Function

Last Updated: 15 July 2025

The LPAD() function in PostgreSQL is a powerful tool for padding a string to the left, ensuring it reaches a specified length by filling it with a designated character or ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - UPPER Function

Last Updated: 01 August 2026

The UPPER() function in PostgreSQL converts all lowercase letters in a string to uppercase.Standardize string values.Perform case-insensitive searches.Format text consiste...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - LOWER function

Last Updated: 01 August 2026

The LOWER() function in PostgreSQL converts all uppercase letters in a string to lowercase based on the database's locale rules.Convert text to lowercase.Standardize strin...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - FORMAT Function

Last Updated: 04 August 2026

PostgreSQL FORMAT() function creates a formatted string by replacing placeholders with specified values. It is commonly used to generate dynamic text, SQL queries and cust...read more

article_image

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CONCAT_WS Function

Last Updated: 15 July 2025

In PostgreSQL, the CONCAT_WS function is a powerful and versatile tool for concatenating strings with a specified separator. This function not only combines multiple strin...read more

article_image

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CONCAT Function

Last Updated: 01 August 2026

PostgreSQL CONCAT() function combines two or more strings into a single string. It is commonly used to merge text values, such as names, addresses, or other character data...read more

article_image

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CHR Function

Last Updated: 15 July 2025

The CHR() function in PostgreSQL is used to convert an integer ASCII code or a Unicode code point into its corresponding character. Let us better understand the concept of...read more

article_image

PostgreSQL-function

PostgreSQL-String-function

1 2