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


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


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

SELECT
    string_agg(elements,'|')
FROM mytable,
    regexp_split_to_table(mystring, '\|') as elements
WHERE split_part(elements, '=', 1) = ANY(ARRAY['TType', 'URL']) IS NOT TRUE


string_agg


Status=OK|day=3

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