On Tuesday 17 August 2004 03:02, Andreas Pflug wrote: > 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. > >
In that case I have no idea how to do it :-( In server-side function I can use parser interface to obtain all column definitions, have no idea how to do it on the client side. Regards ! ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html