Similar Topics

Web Technologies

37.6k+ articles

DSA

21.8k+ articles

Python

20k+ articles

Experiences

13k+ articles

Interview Experiences

11.6k+ articles

JavaScript

10.4k+ articles

Java

10.2k+ articles

PostgreSQL

290+ articles

ASCII

140+ articles

PostgreSQL-function

47 articles

PostgreSQL-String-function

16 posts

PostgreSQL - Substring Function

Last Updated: 01 February 2021

In PostgreSQL, the substring function is used to extract a substring from a string.Syntax: SUBSTRING ( string, start_position, length )Let's ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - SPLIT_PART Function

Last Updated: 16 July 2021

The PostgreSQL SPLIT_PART() function is used to split a string from a specific delimiter and these queries return the nth substring.Syntax: ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - RIGHT Function

Last Updated: 01 February 2021

The PostgreSQL RIGHT() function is used to query for the last n characters in a string.Syntax: RIGHT(string, n)Let's analyze the above synta ...read more

PostgreSQL-function

PostgreSQL-String-function

Similar Topics

Web Technologies

37.6k+ articles

DSA

21.8k+ articles

Python

20k+ articles

Experiences

13k+ articles

Interview Experiences

11.6k+ articles

JavaScript

10.4k+ articles

Java

10.2k+ articles

PostgreSQL

290+ articles

ASCII

140+ articles

PostgreSQL-function

47+ articles

PostgreSQL - REPLACE Function

Last Updated: 01 February 2021

In PostgreSQL, the REPLACE function is used to search and replace all occurrences of a string with a new one.Syntax: REPLACE(source, old_tex ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - REGEXP_MATCHES Function

Last Updated: 07 October 2022

The PostgreSQL REGEXP_MATCHES() function is used to match a POSIX regular expression against a string and subsequently returns the strings t ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CONCAT_WS Function

Last Updated: 08 October 2021

In PostgreSQL, the CONCAT_WS function is used to concatenate strings with a separator. Like the CONCAT function, the CONCAT_WS function is a...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL- CONCAT Function

Last Updated: 08 February 2021

In PostgreSQL, the CONCAT function is used to concatenate two or more strings into one.Syntax: CONCAT(string_1, string_2, ...)Let's analyze ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CHR Function

Last Updated: 08 February 2021

The PostgreSQL CHR() function is used to convert an integer ASCII code to a character or a Unicode code point to a UTF8 character.Syntax: CH...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - POSITION Function

Last Updated: 01 February 2021

The PostgreSQL POSITION() function returns the location of a substring in a string.Syntax: POSITION(substring in string)Let's analyze the ab...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - MD5 Function

Last Updated: 01 February 2021

The PostgreSQL MD5() function is used to evaluate the MD5hash of a string and subsequently return the result. The result is generally in hex ...read more

PostgreSQL-String-function

PostgreSQL - TRIM Function

Last Updated: 01 February 2021

In PostgreSQL, the TRIM() function is used to remove the longest string consisting of spaces or any specified character from a string. By d ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL- LPAD Function

Last Updated: 01 February 2021

The PostgreSQL LPAD() function is used for padding a string to the left by a specified length with other specified characters.Syntax: LPAD(s ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - UPPER function

Last Updated: 28 August 2020

In PostgreSQL, the UPPER function is used to convert a string into upper case.Syntax: UPPER(string_expression)Like the LOWER function, the U ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL- LOWER function

Last Updated: 08 October 2021

In PostgreSQL, the LOWER function is used to convert a string, an expression, or values in a column to lower case.Syntax: LOWER(string or va...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - FORMAT Function

Last Updated: 25 August 2021

In PostgreSQL, the FORMAT() function is used to format arguments based on a format string.Syntax:FORMAT(format_string [, format_argument [, ...read more

PostgreSQL-function

PostgreSQL-String-function