Does PostgreSQL support Constant Expression (Alias Name)? - Mailing list pgsql-general

If  a table has columns fname, lname.
I want to do query like

SELECT fname "First Name", lname "Last Name" FROM aTable;

This SELECT statement is fine in Oracle, Sybase and Informix.
But I get an error message in PostgreSQL

Because I want the output like

First Name | Last Name
--------------------------
fn               | ln

instead default like

fname | lname
---------------
fn       | ln

What is the correct way doing this in PostgreSQL?
Thank you very much in advance!



--Raymond