Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#1331 (ok 3.5.0) Display structure of views

fixed
nobody
1
2013-06-11
2011-10-22
Greg Roach
No

When clicking on the "structure" link/tab for a view, you see the structure of the result-set.

It would be useful also to see the view definition.

This can be obtained from the information schema in views.view_definition

For bonus points(!) make this editable. e.g. allow the user to edit the defintion, and then execute it by prefixing "CREATE OR REPLACE <view_name> AS" to the definition.

Discussion

  • Marc Delisle
    Marc Delisle
    2011-12-10

    On the Structure page for the view, there is now "Edit view".

     
  • Marc Delisle
    Marc Delisle
    2011-12-10

    This requested feature was implemented in the repository and will be part of a future release; thanks for suggesting.

     
  • Marc Delisle
    Marc Delisle
    2011-12-10

    • priority: 5 --> 1
    • summary: Display structure of views --> (ok 3.5.0) Display structure of views
    • status: open --> open-accepted
     
  • Marc Delisle
    Marc Delisle
    2012-04-07

    • status: open-accepted --> closed-accepted
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-accepted --> fixed