Re: [HACKERS] Rules for 6.4 finished

jwieck@debis.com (Jan Wieck)
>
> > >     Another topic is if we should create some more  system  views
> > >     at  initdb  time.  I  would  find views telling ownership and
> > >     other information readable instead of Oid's very  useful.  As
> > >     for pg_rule and pg_view it would be possible to create a view
> > >     that describes the definition of an  index  instead  of  some
> > >     cryptic  numbers.  And  another  one  for  real  tables where
> > >     indices and views are omitted would also be useful.
> >
> > Yes, these are good ideas.
> >
> > --
> > Bruce Momjian                          |  830 Blythe Avenue
>
>     I'm  running into some naming problems while doing so. Having
>     pg_table, pg_view etc. as views lets a users assume  pg_index
>     would  be one too where to get some information. But pg_index
>     already exists.
>
>     Should I name all of them pgv_... ?
>
>     Other databases have many views starting with DBA or  SYS  on
>     the  other  hand.  For now I'll start naming them pgv_..., we
>     could rename them before applying the patch.
>

Jan,

How about using the plural?

pg_views, pg_rules, pg_tables, pg_indexes etc...

It also seems more natural to me.

Keith.