how to append additional characters into a string in postgresql

Question

For Example let's take The quick brown fox jumps over the lazy dog is the string.
In this string I need to append _ instead of spaces in between two words and append word tag: in front of each word.

i.e
tag:The_tag:quick_tag:brown_tag:fox_tag:jumps_tag:over_tag:the_tag:lazy_tag:dog

How to do this with Postgresql

I've tried

select replace('The quick brown fox jumps over the lazy dog', ' ', '_')

Have you consulted the fine manual?

mu is too short
– mu is too short

2014-09-16 06:09:18 +00:00
Commented Sep 16, 2014 at 6:09 — mu is too short
– mu is too short, Commented Sep 16, 2014 at 6:09

Vivek S. · Accepted Answer · 2014-09-16 06:14:25Z

1

Try,

SELECT 
     string_agg (b.tag,'_') as my_string
FROM (
      select  'tag:'||c.unnest||''  as tag 
      from (select unnest(string_to_array('The quick brown fox jumps over the lazy dog', ' '))) c
) b

answered Sep 16, 2014 at 6:14

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to append additional characters into a string in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related