Getting data from Postgres

Question

I'm using Postgres, I've this table:

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

and

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

and I would like to get the following output

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

What query can be used for get these output,.? thanks,.

Adam Wenger · Accepted Answer · 2011-11-22 03:32:33Z

3

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

answered Nov 22, 2011 at 3:32

Adam Wenger

17.7k8 gold badges55 silver badges65 bronze badges

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

Comments

Larry Lustig · Accepted Answer · 2011-11-22 03:31:18Z

1

 SELECT fieldname, value FROM this_table
 UNION ALL 
 SELECT dyn_field, dyn_value FROM and_table

(You didn't specify the table names, so I made them up).

answered Nov 22, 2011 at 3:31

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

emco · Accepted Answer · 2011-11-22 03:32:50Z

1

Try this:

SELECT fieldname as field, value 
FROM table1 
UNION select dyn_field as field, dyn_value as value 
FROM table2

answered Nov 22, 2011 at 3:32

emco

4,7493 gold badges20 silver badges20 bronze badges