Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table online_websites (
  amazon int,
  flipkart int,
  myntra int
);

insert into online_websites values (5, 4, 3);
1 rows affected

select e.*
  from online_websites
       cross join lateral jsonb_each_text(
                            to_jsonb(online_websites)
                          ) as e(website_name, "count");


website_name
count


amazon
5

myntra
3

flipkart
4


alter table online_websites add column ebay int;

update online_websites set ebay = 2;
1 rows affected

select e.*
  from online_websites
       cross join lateral jsonb_each_text(
                            to_jsonb(online_websites)
                          ) as e(website_name, "count");


website_name
count


ebay
2

amazon
5

myntra
3

flipkart
4