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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
