psql :: support for \ev viewname and \sv viewname - Mailing list pgsql-hackers

From Petr Korobeinikov
Subject psql :: support for \ev viewname and \sv viewname
Date
Msg-id CAJL5ff_vLBvxwy+V+yA6s+h5yhdDWDrz+koqHXbAZ0x99vE1iA@mail.gmail.com
Whole thread Raw
Responses Re: psql :: support for \ev viewname and \sv viewname  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: psql :: support for \ev viewname and \sv viewname  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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)

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?
Attachment

pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Disabling trust/ident authentication configure option
Next
From: Bernd Helmle
Date:
Subject: Re: cost_index() and path row estimate.