Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
zhulinpinyu opened this issue Jun 21, 2017 · 0 comments
Open

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

zhulinpinyu opened this issue Jun 21, 2017 · 0 comments
Labels

Comments

@zhulinpinyu
Copy link
Owner

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant