sql - 从 Postgres 获取数据

Question

我正在使用 Postgres，我有这张表:

id | fieldname | value
----------------------
1  | price     | 10000

和

id | dyn_field | dyn_value
--------------------------
1  | bathroom  | 2
2  | bedroom   | 4

我想得到以下输出

field     | value
---------------------
price     | 10000
bathroom  | 2
bedroom   | 4

可以使用什么查询来获取这些输出，.?谢谢。

Answer 1

SELECT fieldname AS field, value AS value
FROM tableOne
UNION ALL
SELECT dyn_field AS field, dyn_value AS value
FROM tableTwo