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
>
>
>