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

From: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, greg(at)turnstep(dot)com, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: \d type queries - why not views in system catalog?!?
Date: 2003-01-13 21:42:59
Message-ID: 1042494179.2298.2.camel@mouse.copelandconsulting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2003-01-13 22:00:53 Re: \d type queries - why not views in system catalog?!?
Previous Message Dave Page 2003-01-13 21:00:44 Re: \d type queries - why not views in system catalog?!?