Postgres数据操纵

Question

所以我有一些看起来像这样的数据;

Column A  |  Column B
__________|__________
Chicken   |     2
Duck      |     8
Cat       |     3 

我如何使它看起来像这样？

  Column C  |
____________|
Chicken = 2 |
Duck = 8    |
Cat = 3     |

Answer 1

尝试像下面的condenate

SELECT clumnA || ' = '|| columnb AS ColumnC
FROM yourTable;

Answer 2

您要使用Concat函数

https://www.postgresql.org/docs/current/functions-string.html#id-1.5.8.9.7.9.7.2.2.4.2.2.4.1.1.1

SELECT CONCAT("Column A", ' = ', "Column B") AS "Column C" FROM [table];