Similar Topics

Web Technologies

41k+ articles

DSA

22.3k+ articles

Python

20.1k+ articles

Experiences

17k+ articles

Interview Experiences

13.6k+ articles

School Learning

12.9k+ articles

Databases

2.3k+ articles

PostgreSQL

380+ articles

ASCII

140+ articles

PostgreSQL-function

47 articles

PostgreSQL-String-function

16 posts

PostgreSQL - Substring Function

Last Updated: 13 November 2024

PostgreSQLis a powerful relational database management system with extensive text processing functions, including the flexibleSUBSTRINGfunct ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - SPLIT_PART Function

Last Updated: 08 November 2024

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

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - RIGHT Function

Last Updated: 26 July 2024

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

PostgreSQL-function

PostgreSQL-String-function

Similar Topics

Web Technologies

41k+ articles

DSA

22.3k+ articles

Python

20.1k+ articles

Experiences

17k+ articles

Interview Experiences

13.6k+ articles

School Learning

12.9k+ articles

Databases

2.3k+ articles

PostgreSQL

380+ articles

ASCII

140+ articles

PostgreSQL-function

47+ articles

PostgreSQL - REPLACE() Function

Last Updated: 14 October 2024

PostgreSQL REPLACE() function is a powerful tool for efficient string manipulation within our database. By utilizing the REPLACE() syntax in ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - REGEXP_MATCHES Function

Last Updated: 19 November 2024

The PostgreSQL REGEXP_MATCHES() function is a powerful tool for matching POSIX regular expressions against a string. It returns substrings t ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CONCAT_WS Function

Last Updated: 05 November 2024

In PostgreSQL, the CONCAT_WS function is a powerful and versatile tool for concatenating strings with a specified separator. This function n...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL- CONCAT Function

Last Updated: 11 November 2024

The PostgreSQL CONCAT function allows us to combine multiple strings or column values into a single output, making it a flexible tool for da...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CHR Function

Last Updated: 26 July 2024

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

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - POSITION Function

Last Updated: 18 July 2024

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

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - MD5() Function

Last Updated: 06 August 2024

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

PostgreSQL-String-function

PostgreSQL - TRIM Function

Last Updated: 11 November 2024

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

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL- LPAD Function

Last Updated: 18 July 2024

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 ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - UPPER Function

Last Updated: 28 July 2024

In PostgreSQL, the UPPER function is utilized to convert a string into uppercase. This function is handy when you need to standardize text d ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - LOWER() function

Last Updated: 06 August 2024

In PostgreSQL, the LOWER() function is a powerful tool used to convert strings, expressions, or values in a column to lowercase. This functi...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - FORMAT Function

Last Updated: 14 October 2024

The PostgreSQL format() function is a powerful tool for string formatting by allowing developers to insert variables into strings using form ...read more

PostgreSQL-function

PostgreSQL-String-function