Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH mytable AS (
    SELECT 'TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3' as mystring
)

SELECT
    *
FROM mytable

mystring

TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3

SELECT 1

WITH mytable AS (
    SELECT 'TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3' as mystring
)

SELECT
    *
FROM mytable,
    regexp_split_to_table(mystring, '\|') as elements

mystring
elements

TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3
TType=SEND

TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3
Status=OK

TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3
URL=min://j?_a=3&ver=1.1

TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3
day=3

SELECT 4

WITH mytable AS (
    SELECT 'TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3' as mystring
)

SELECT
    split_part(elements, '=', 1)
FROM mytable,
    regexp_split_to_table(mystring, '\|') as elements

split_part

TType

Status

URL

day

SELECT 4

WITH mytable AS (
    SELECT 'TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3' as mystring
)

SELECT
    string_agg(
        split_part(elements, '=', 1), 
        ','
    )
FROM mytable,
    regexp_split_to_table(mystring, '\|') as elements

string_agg

TType,Status,URL,day

SELECT 1

mystring	elements
TType=SEND\|Status=OK\|URL=min://j?_a=3&ver=1.1\|day=3	TType=SEND
TType=SEND\|Status=OK\|URL=min://j?_a=3&ver=1.1\|day=3	Status=OK
TType=SEND\|Status=OK\|URL=min://j?_a=3&ver=1.1\|day=3	URL=min://j?_a=3&ver=1.1
TType=SEND\|Status=OK\|URL=min://j?_a=3&ver=1.1\|day=3	day=3