Re: \d type queries - why not views in system catalog?!? - Mailing list pgsql-hackers

From Robert Treat
Subject Re: \d type queries - why not views in system catalog?!?
Date
Msg-id 1042495253.20991.27.camel@camel
Whole thread Raw
In response to Re: \d type queries - why not views in system catalog?!?  (Greg Copeland <greg@CopelandConsulting.Net>)
Responses Re: \d type queries - why not views in system catalog?!?
List pgsql-hackers
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@CopelandConsulting.Net] 
> > > Sent: 13 January 2003 20:56
> > > To: Robert Treat
> > > Cc: greg@turnstep.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@copelandconsulting.net>
> Copeland Computer Consulting
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org




pgsql-hackers by date:

Previous
From: Greg Copeland
Date:
Subject: Re: \d type queries - why not views in system catalog?!?
Next
From: Hannu Krosing
Date:
Subject: Re: \d type queries - why not views in system catalog?!?