How to get required space between field names - Mailing list pgsql-general

From shreedhar
Subject How to get required space between field names
Date
Msg-id 007a01c31e99$9e81c480$1201a8c0@a4005
Whole thread Raw
Responses Re: How to get required space between field names
Re: How to get required space between field names
List pgsql-general
Hi All,
 
How to get required space between field names.
 
example.
field name is : contactid
But I would like to display it as 'Contact Id' in my report.
 
If I write query like in SQLServer 2000 I am getting an error.
 
* SELECT contactid AS [Contact Id] FROM tContacts;
 
How can I get similar to above operation.
 
Thanks & Regards,
Sreedhar Bhaskararaju
 
Our greatest happiness in life does not depend on the condition of life in which chance has placed us, but is always the result of good conscience, good health, occupation, and freedom in all just pursuits

pgsql-general by date:

Previous
From: Gianni Mariani
Date:
Subject: Re: are views obsolete ?
Next
From: "shreedhar"
Date:
Subject: How to get required space between field names