X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 324AAD1B181
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Mon,  5 Jul 2004 00:59:44 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 65803-01
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Mon,  5 Jul 2004 03:59:39 +0000 (GMT)
Received: from mako1.telstra.net (mako1.telstra.net [203.50.0.28])
	by svr1.postgresql.org (Postfix) with ESMTP id CF6DAD1B1D9
	for <pgsql-hackers@postgresql.org>;
	Mon,  5 Jul 2004 00:59:37 -0300 (ADT)
Received: from telstra.net (xena.telstra.net [203.50.0.233])
	by mako1.telstra.net (8.12.9/8.11.1) with ESMTP id i653xVB4018331;
	Mon, 5 Jul 2004 13:59:31 +1000 (EST) (envelope-from jc@telstra.net)
Message-ID: <40E8D1D2.3000307@telstra.net>
Date: Mon, 05 Jul 2004 13:58:10 +1000
From: Justin Clift <jc@telstra.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20040406
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Subject: Re: Adding column comment to information_schema.columns
References: <40E37E3F.2050400@telstra.net> <22066.1088656403@sss.pgh.pa.us>	
	<40E3949F.6020201@telstra.net>
	<40E3BB25.4020804@pse-consulting.de>	
	<k6xn3cph.fsf@bullysports.com>
	<40E4C305.4070309@familyhealth.com.au>	
	<40E4C367.2080303@telstra.net>
	<1088769438.15415.1.camel@fuji.krosing.net>
	<40E5716D.70403@familyhealth.com.au> <40E8C27E.2050505@telstra.net>
	<40E8C6CE.80405@familyhealth.com.au>
In-Reply-To: <40E8C6CE.80405@familyhealth.com.au>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200407/215
X-Sequence-Number: 55776

Christopher Kings-Lynne wrote:
<snip>
> Anyone who's writing queries that are examing the schema of the database 
> is by definition not a newbie...

By newbie here, I mean someone who's a PG "newbie" but has a reasonable 
understanding of databases (i.e. Oracle, etc) would generally find the 
"information_schema" much easier to locate and use information in 
compared to having to learn the PG internals.

There's a whole lot of difference between the skill level needed to 
query the information_schema and find out things like table and column 
names, vs looking into pg_namespace, pg_class and pg_attribute plus 
understanding the specific info there to work out table and column names.

I reckon that having information "pre-prepared" in views like those in 
information_schema is "of course" going to be easier for people than 
"raw" information our internal catalogs.

Do you get where I'm coming from with this?

Regards and best wishes,

Justin Clift

> Chris
> 
> 
>