Re: \d type queries - why not views in system catalog?!?

You have to do it in functions because some of the \ commands use
multiple queries and logic inside the C code.

Robert Treat

On Mon, 2003-01-13 at 16:42, Greg Copeland wrote:
> Views or C-functions, I think the idea is excellent. It's the concept
> that I really like.
>
> Greg
>
>
> On Mon, 2003-01-13 at 15:00, Dave Page wrote:
> > > -----Original Message-----
> > > From: Greg Copeland [mailto:greg(at)CopelandConsulting(dot)Net]
> > > Sent: 13 January 2003 20:56
> > > To: Robert Treat
> > > Cc: greg(at)turnstep(dot)com; PostgresSQL Hackers Mailing List
> > > Subject: Re: [HACKERS] \d type queries - why not views in
> > > system catalog?!?
> > >
> > >
> > > Oh!
> > >
> > > That's an excellent idea. Seemingly addresses the issue and
> > > has value-add. I'm not aware of any gotchas here. Is there
> > > something that is being overlooked?
> >
> > Why use functions instead of views? Most UIs will want to format the
> > output as they see fit so a recordset would be the appropriate output.
> > Yes, a function could do this, but surely views would be simpler to
> > implement and maintain.
> >
> > Regards, Dave.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> --
> Greg Copeland <greg(at)copelandconsulting(dot)net>
> Copeland Computer Consulting
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org