Alias from column name should be seperated with "as"

In PostgreSql it is not allowed to use column alias without 'as' keyword, e.g. 'select dname n from dept' will not execute