PostgreSQL – INITCAP Function

ByAdmin

The initcap function in PostgreSQL database is used to capitalize the first letter of each word in a string, while converting all other letters to lowercase. It’s often used to format text in a more readable or proper case.

Here’s the syntax for the initcap function:

initcap(input_string)
  • input_string is the string that you want to capitalize.

The initcap function takes the input_string and returns a new string with the first letter of each word in uppercase and all other letters in lowercase.

Here’s an example of how to use the initcap function:

SELECT initcap('hello world');

In this example, the initcap function is used to capitalize the first letter of each word in the string 'hello world'. The result of this query will be 'Hello World'.

It’s important to note that initcap doesn’t consider certain characters (like spaces, punctuation, etc.) as word separators, so it will capitalize the first letter following these characters as well.

Here’s another example:

SELECT initcap('the quick brown-fox, jumps over the lazy dog');

The result of this query will be 'The Quick Brown-Fox, Jumps Over The Lazy Dog'.

Similar Posts

PostgreSQL – REVERSE Function

ByAdmin

The REVERSE function is used to reverse the order of characters in a given string. It takes a string as an argument and returns a new string with the characters reversed. Here’s the basic syntax of the REVERSE function: REVERSE(string) Here’s an example of using the REVERSE function: SELECT REVERSE(‘Hello, World!’); — Returns ‘!dlroW ,olleH’…

PostgreSQL – REPLACE Function

ByAdmin

The REPLACE function is used to replace all occurrences of a specified substring within a given string with another substring. The syntax of the REPLACE function is as follows: REPLACE(string, old_substring, new_substring) where string is the input string in which you want to perform replacements, and old_substring is the substring you want to replace within…