Skip to content
Courses
DSA to Development
Get IBM Certification
Newly Launched!
Master Django Framework
Become AWS Certified
For Working Professionals
Interview 101: DSA & System Design
Data Science Training Program
JAVA Backend Development (Live)
DevOps Engineering (LIVE)
Data Structures & Algorithms in Python
For Students
Placement Preparation Course
Data Science (Live)
Data Structure & Algorithm-Self Paced (C++/JAVA)
Master Competitive Programming (Live)
Full Stack Development with React & Node JS (Live)
Full Stack Development
Data Science Program
All Courses
Tutorials
Data Structures & Algorithms
ML & Data Science
Interview Corner
Programming Languages
Web Development
CS Subjects
DevOps And Linux
School Learning
Practice
Build your AI Agent
GfG 160
Problem of the Day
Practice Coding Problems
GfG SDE Sheet
Contests
Accenture Hackathon (Ending Soon!)
GfG Weekly [Rated Contest]
Job-A-Thon Hiring Challenge
All Contests and Events
DSA
Practice Problems
C
C++
Java
Python
JavaScript
Data Science
Machine Learning
Courses
Linux
DevOps
SQL
Web Development
System Design
Aptitude
GfG Premium
Sign In
▲
Similar Topics
Web Technologies
39.1k+ articles
DSA
22.5k+ articles
Python
20.4k+ articles
Experiences
16.7k+ articles
Interview Experiences
14k+ articles
JavaScript
11.7k+ articles
Databases
2.2k+ articles
PostgreSQL
380+ articles
ASCII
140+ articles
PostgreSQL-function
47 articles
PostgreSQL-String-function
16 posts
Popular Articles
Recent Articles
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
PostgreSQL-function
PostgreSQL-String-function
Databases
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
PostgreSQL-function
PostgreSQL-String-function
Databases
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
PostgreSQL-function
PostgreSQL-String-function
Similar Topics
Web Technologies
39.1k+ articles
DSA
22.5k+ articles
Python
20.4k+ articles
Experiences
16.7k+ articles
Interview Experiences
14k+ articles
JavaScript
11.7k+ articles
Databases
2.2k+ 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
PostgreSQL-function
PostgreSQL-String-function
Databases
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
PostgreSQL-function
PostgreSQL-String-function
Databases
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
PostgreSQL-function
PostgreSQL-String-function
Databases
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
PostgreSQL-function
PostgreSQL-String-function
Databases
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
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
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
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
PostgreSQL-function
PostgreSQL-String-function
Databases
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
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
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
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
PostgreSQL-function
PostgreSQL-String-function
Databases
1
2
>>
Last
1
2
>>
Last
1
2
>>
Last
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our
Cookie Policy
&
Privacy Policy
Got It !