Re: How to get required space between field names

M$:
SELECT contactid AS [Contact Id] FROM tContacts;


PostGRE:
SELECT contactid AS "Contact Id" FROM tContacts;



shreedhar wrote:
> 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