Re: psql :: support for \ev viewname and \sv viewname

2015-05-04 11:21 GMT+02:00 Petr Korobeinikov <pkorobeinikov@gmail.com>:

> Hackers!
>
> I'm proposing to add two new subcommands in psql:
> 1. \ev viewname - edit view definition with external editor (like \ef for
> function)
> 2. \sv viewname - show view definition (like \sf for function, for
> consistency)
>

+1

Pavel


>
> What's inside:
> 1. review-ready implementation of \ev and \sv psql subcommands for editing
> and viewing view's definition.
> 2. psql's doc update with new subcommands description.
> 3. a bit of extracting common source code parts into separate functions.
> 4. psql internal help update.
> 5. tab completion update.
>
> There is one narrow place in this patch: current implementation doesn't
> support "create" statement formatting for recursive views.
>
> Any comments? Suggestions?
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>