Array to string conversion with delimiter pipe | in PostgreSQL

Question

I need to form a string from a given array.

Suppose array[1] = gvk, array[2] = gvk1 and array[3] = gvk2, then I need to get these values into a string like:

Mystring = gvk | gvk1 | gvk2

user272735 · Accepted Answer · 2012-07-31 19:19:33Z

56

I think you can use the array_to_string function here :

array_to_string(anyarray, text) --> text
concatenates array elements using supplied delimiter

Example:

scalasb=> select array_to_string(ARRAY[1, 2, 3], '~^~');
 array_to_string 
-----------------
 1~^~2~^~3
(1 row)

scalasb=>

edited Jul 31, 2012 at 19:19

user272735

10.6k9 gold badges72 silver badges100 bronze badges

answered Jun 4, 2010 at 11:44

Peter Tillemans

35.4k11 gold badges85 silver badges117 bronze badges

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

Comments

Mark Baker · Accepted Answer · 2010-06-04 11:41:29Z

0

The MS SQL to POSTGRES Blogspot has a demonstration of how to implement a group_concat function in Postgres. It should be pretty straightforward to modify it to include a separator

answered Jun 4, 2010 at 11:41

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Collectives™ on Stack Overflow

Array to string conversion with delimiter pipe | in PostgreSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related