Re: How to get required space between field names

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>
Cc: shreedhar <shreedhar(at)lucidindia(dot)net>, lahari_sree(at)rediffmail(dot)com, Postgre General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get required space between field names
Date: 2003-05-20 11:45:20
Message-ID: Pine.LNX.4.21.0305201244100.14538-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 20 May 2003, Darko Prenosil wrote:

> SELECT contactid AS "Contact Id" FROM "tContacts";
>
> Be very careful with mixing upper and lower cases in object names.
> If Your table name is upper or mixed case You must quote it too, as shown
> in example.
>

It's amazing how many of us failed to think about the table name in that
question.

--
Nigel Andrews

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-05-20 12:15:14 Having problems with anoncvs
Previous Message Richard Huxton 2003-05-20 11:40:54 Re: PRIMARY KEYS