test=# create table tossi(key text, value text);
CREATE TABLE
test=*# insert into tossi values ('Key1','Val1');
INSERT 0 1
test=*# insert into tossi values ('Key2','Val2');
INSERT 0 1
test=*# insert into tossi values ('Key3','Val3');
INSERT 0 1
test=*# select * from tossi ;
key | value
------+-------
Key1 | Val1
Key2 | Val2
Key3 | Val3
(3 rows)
test=*# select key, value from tossi ;
key | value
------+-------
Key1 | Val1
Key2 | Val2
Key3 | Val3
(3 rows)
test=*# select (key, value) from tossi ;
row
-------------
(Key1,Val1)
(Key2,Val2)
(Key3,Val3)
(3 rows)
test=*# select key || '=' || value from tossi;
?column?
-----------
Key1=Val1
Key2=Val2
Key3=Val3
(3 rows)
test=*# select '(' || key || '=' || value || ')' from tossi;
?column?
-------------
(Key1=Val1)
(Key2=Val2)
(Key3=Val3)
(3 rows)
test=*#