Re: \d type queries - why not views in system catalog?!?
От | Robert Treat |
---|---|
Тема | Re: \d type queries - why not views in system catalog?!? |
Дата | |
Msg-id | 1042495253.20991.27.camel@camel обсуждение исходный текст |
Ответ на | Re: \d type queries - why not views in system catalog?!? (Greg Copeland <greg@CopelandConsulting.Net>) |
Ответы |
Re: \d type queries - why not views in system catalog?!?
|
Список | 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 по дате отправления: