On Mon, 23 Feb 1998, Bruce Momjian wrote:
> >
> > On Mon, 23 Feb 1998, Bruce Momjian wrote:
> >
> > >
> > > Can I suggest pgview_ then? Another problem is that a \d on an empty
> > > database, \d is going to show this view, isn't it. Kind of strange to
> > > me.
> >
> > I modified psql already such that:
> >
> > relname !~ '^[pd][bg]_'
> >
> > is ignored :)
>
> I still disagree. Why not keep the system stuff pg_? This can be done,
> and it keeps things consistent. The above check also finds pb_ and dg_.
Actually, I'm not married to db_* for views...it was a "quick fix"
to ensure that things still worked. Whatever we decide on, both Julie and
Peter, at a minimum, need to know relatively soon. I know in Julie's
case, she does do a call to pg_user...I let her know tonight that she
needs to change it to db_user, for the *current* code...
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org