Thread: schemas and system tables

schemas and system tables

From
"Merlin Moncure"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Is it feasible and/or advantageous to move all the system tables to a system schema (to “system” or
“<spanclass="SpellE">pg_system</span>”)?<span style="mso-spacerun:yes">  </span>This seems a much more natural place
forthis type of information.<span style="mso-spacerun:yes">  </span>This would remove the artificial ‘pg_’ restriction
onclass names and simplify the overall system a little bit.<span style="mso-spacerun:yes">  </span><span
class="GramE">Justa thought.</span></span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Regards,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Merlin</span></font></div>

Re: schemas and system tables

From
Stephan Szabo
Date:
On Wed, 6 Aug 2003, Merlin Moncure wrote:

> Is it feasible and/or advantageous to move all the system tables to a
> system schema (to "system" or "pg_system")?  This seems a much more
> natural place for this type of information.  This would remove the
> artificial 'pg_' restriction on class names and simplify the overall
> system a little bit.  Just a thought.

I believe 7.3 already did this with pg_catalog.