The table function returns a list of rows for each input. Table Function Syntax

SELECT expr (, expr)*
FROM (Table | SubQuery),
LATERAL TABLE '('TableFunctionRef')' AS Identifier '(' Identifier (,Identifier)* ')'

split

Syntax

    split(string text)
    split(string text, string separator)

Description Split the text to a list of single string by the separator. The default separator is: ','.

Example

SELECT t.id, u.name FROM users u, LATERAL table(split(u.ids)) as t(id);
SELECT t.id, u.name FROM users u, LATERAL table(split(u.ids, ',')) as t(id);