Well,

I have find out the query which shows the coming week birthdays but the only problem is it is not showing in the order.

SELECT * FROM employees WHERE to_char(birth_date,'ddd')::int-to_char(now(),'DDD')::int between 0 and 8 ;

if in db records are
name | birth
-------+------------
One | 02/18/1981
Two | 02/16/1985
Three | 03/27/1976
Four | 02/21/1970
Five | 02/15/1986
Six | 07/15/1981

then the output should be as follows

02/15/1986
02/16/1985
02/18/1981
02/21/1970