Re: TODO item: columns of Views: show properties

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

Darko Prenosil wrote:
> I see in todo an item:
>     columns of Views: show properties
>
> and maybe I have a solution. I have written a "c" (backend) function that
> can return the same structure as "pg_class" for any query, and that means
> indirectly that it can return all columns definitions for view too. It is
> important that it can tell for each column to which table it belongs.
> Concerning pgAdmin already has some server-side functions, could this be a
> solution ?

No, server-side support functions are really only the very last solution 
to consider. pgAdmin3 should run out-of-the-box as much as possible.
What has to be done is put all applicable table subitems under view also.


Regards,
Andreas