Re: capitalized sql (was: Re: Changing the default value of an inherited column)

At 12:04 3/04/01 +0200, Zeugswetter Andreas SB wrote:
>
>> will get dumped as:
>>
>> CREATE TABLE "c5" (
>> "f1" integer NOT NULL,
>> "f3" integer
>> )
>> inherits ("p3_def1");
>
>As an aside answer without considerable importance:
>
>Why do people tend to write SQL keywords in all capitals ?

It's just one of those things that people do; some people find it easier to
read (I actually prefer proper case keywords for SQL, unquoted upper case
for names etc):

Create Table C5 (
F1 Integer Not Null,
F3 Integer
)
Inherits (P3_DEF1);

As to why it's in pg_dump, I think it reflects the many & varied
contributors as opposed to careful design. There is some proper-case stuff
in there now (from me), which I will try to remember to remove. The upper
case stuff is there since 6.x at least, and I'm not sure why INHERITS is in
lower case. Type names are now formatted (mostly) using formatType (from
Peter E), so they will at least be consistent (and lower case).

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/