Postgresql 合并多个字段为一个字段

[zhulinpinyu]

a and b is TABLE field

select concat(a,'---',b) as ab from TABLE

OR

select a||'---'||b as ab from TABLE

Result is:

Field	Value
ab	a_value---b_value