Postgres 15

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

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

create table your_table as select 
  'Canada' as country_name, 
  'CA' as country_code, 
  'CAD' as currency_code;

SELECT 1

select  jsonb_build_object(
                    'country_name', country_name,
                    'country_code', country_code,
                    'currency_code', currency_code
                )
from your_table;

jsonb_build_object

{"country_code": "CA", "country_name": "Canada", "currency_code": "CAD"}

SELECT 1

select  jsonb_build_object(
                    'country_name', country_name,
                    'country_code', country_code,
                    'currency_code', currency_code
                ) my_column_name
from your_table;

my_column_name

{"country_code": "CA", "country_name": "Canada", "currency_code": "CAD"}

SELECT 1