How to get required space between field names

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: <lahari_sree(at)rediffmail(dot)com>, "Postgre General" <pgsql-general(at)postgresql(dot)org>
Subject: How to get required space between field names
Date: 2003-05-20 06:31:49
Message-ID: 007a01c31e99$9e81c480$1201a8c0@a4005
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shreedhar 2003-05-20 06:34:34 How to get required space between field names
Previous Message Tom Lane 2003-05-20 04:58:41 Re: ERROR: Memory exhausted in AllocSetAlloc(188)