Get alias name dynamically in Postgresql

Question

I have one table named tblalias.which is having two columns cid, description

cid                  description
1                    Employee
2                    Join Date
3                    Retire Date

Like this three record is present

Now I have another table tblemployee. I want to write a query for tblemployee to get record but alias name for that query I want should come from tblalias

select nama as Employee,
       joindate as "Join Date",
       retiredate as "Retire Date" 
from tblemployee

If I change value is tblalias table to my select query should return new value as alias is it possible if yes how please help me

dynamic mean the alias name in my select query will come from tblalias table that is not hard code — Deepak Kumar

a_horse_with_no_name a_horse_with_no_name · Accepted Answer · 2011-09-09T11:02:29

The only way to do this is with dynamic SQL. First fetch the alias names then build the final SQL and execute it.

There is no way doing this with a single "hardcoded" statement.

Get alias name dynamically in Postgresql

2 Answers