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

From Dave Page
Subject Re: \d type queries - why not views in system catalog?!?
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8259A94@mail.vale-housing.co.uk
Whole thread Raw
In response to \d type queries - why not views in system catalog?!?  (Joerg Hessdoerfer <Joerg.Hessdoerfer@sea-gmbh.com>)
Responses Re: \d type queries - why not views in system catalog?!?  (Greg Copeland <greg@CopelandConsulting.Net>)
List pgsql-hackers

> -----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.


pgsql-hackers by date:

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