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

What about querying the information_schema?

Chris

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Robert Treat
> Sent: Tuesday, 14 January 2003 6:01 AM
> To: Greg Copeland
> Cc: Dave Page; greg(at)turnstep(dot)com; PostgresSQL Hackers Mailing List
> Subject: Re: [HACKERS] \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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>