How to get required space between field names

Started by shreedharalmost 23 years ago6 messagesgeneral
Jump to latest
#1shreedhar
shreedhar@lucidindia.net

Hi All,

How to get required space between field names

Example :

SELECT contactid AS [Contact Id] FROM tContacts.

How can I write similar Query in Postgre.

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

#2Shridhar Daithankar
shridhar_daithankar@persistent.co.in
In reply to: shreedhar (#1)
Re: How to get required space between field names

On 20 May 2003 at 12:04, shreedhar wrote:

Hi All,

How to get required space between field names

Example :

SELECT contactid AS [Contact Id] FROM tContacts.

Just a guess

SELECT contactid AS ["Contact Id"] FROM tContacts;

HTH

Bye
Shridhar

--
Harrison's Postulate: For every action, there is an equal and opposite
criticism.

#3Karsten Hilbert
Karsten.Hilbert@gmx.net
In reply to: shreedhar (#1)
Re: How to get required space between field names

SELECT contactid AS [Contact Id] FROM tContacts.

SELECT contactid AS "Contact Id" FROM tContacts

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

#4Kaare Rasmussen
kar@kakidata.dk
In reply to: shreedhar (#1)
Re: How to get required space between field names

Hi

It is enough to post the question one time only.

SELECT contactid AS [Contact Id] FROM tContacts.

SELECT contactid AS "Contact Id" FROM tContacts.

--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 �ben 12.00-18.00 Email: kar@kakidata.dk
2000 Frederiksberg L�rdag 12.00-16.00 Web: www.suse.dk

In reply to: shreedhar (#1)
Re: How to get required space between field names

This should work

SELECT contactid AS "[Contact Id]" FROM tContacts.

Show quoted text

On Вторник, 20 Май 2003 13:34, shreedhar wrote:

Hi All,

How to get required space between field names

Example :

SELECT contactid AS [Contact Id] FROM tContacts.

How can I write similar Query in Postgre.

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

#6Nigel J. Andrews
nandrews@investsystems.co.uk
In reply to: Shridhar Daithankar (#2)
Re: How to get required space between field names

On Tue, 20 May 2003, Shridhar Daithankar wrote:

On 20 May 2003 at 12:04, shreedhar wrote:

Hi All,

How to get required space between field names

Example :

SELECT contactid AS [Contact Id] FROM tContacts.

Just a guess

SELECT contactid AS ["Contact Id"] FROM tContacts;

Some one left their brain on the dressing table this morning...oh wait, that
was me.

Anyway, I think shreedhar is looking more for:

SELECT contactid AS "Content Id" FROM tContacts;

--
Nigel Andrews