PostgreSQL: regexp_split_to_array to Split String using different Delimiters

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am providing a solution to split a string by using a different type of delimiters in PostgreSQL.
Splitting a string is a very common requirement for all PostgreSQL Database Developers.
I used regexp_split_to_array to split the string and store the result into a string array. You can pass any delimiters.

Below are two sample example using regexp_split_to_array():

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

SELECT a[1] AS DiskInfo ,a[2] AS DiskNumber ,a[3] AS MessageKeyword FROM (     SELECT regexp_split_to_array('Postgres Disk information : disk 2 : failed', ':') ) AS dt(a)     SELECT a[1] AS DiskInfo ,a[2] AS DiskNumber ,a[3] AS MessageKeyword FROM (     SELECT regexp_split_to_array('Postgres Disk information , disk 2 , failed', ',') ) AS dt(a)

The result: