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