By default when we run an query in postgres sql (psql) , all the table header is in lowercase , this is different with mysql. To keep the header as you want you have to put the column name in ”

for example:

select firstname as "FirstName" , LastName as "LastName" from users