Postgres 14

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

CREATE TABLE tbl (sample text);
INSERT INTO tbl VALUES
('I
am
Awesome');
1 rows affected

SELECT string_agg(id || '.' ||word,E'\n')
FROM tbl
CROSS JOIN LATERAL 
  unnest(string_to_array(sample,E'\n')) WITH ORDINALITY j (word,id)
GROUP BY sample; 


string_agg


1.I
2.am
3.Awesome


SELECT id || '.' ||word
FROM tbl
CROSS JOIN LATERAL 
  unnest(string_to_array(sample,E'\n')) WITH ORDINALITY j (word,id);


?column?


1.I

2.am

3.Awesome