From: Justin Clift <jc@telstra.net>
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
Date: Mon, 05 Jul 2004 13:58:10 +1000
Message-ID: <40E8D1D2.3000307@telstra.net> (raw)
In-Reply-To: <40E8C6CE.80405@familyhealth.com.au>
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>
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
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: jc@telstra.net, chriskl@familyhealth.com.au
Subject: Re: Adding column comment to information_schema.columns
In-Reply-To: <40E8D1D2.3000307@telstra.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox