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

From: Petr Korobeinikov <pkorobeinikov(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: psql :: support for \ev viewname and \sv viewname
Date: 2015-05-04 09:21:43
Message-ID: CAJL5ff_vLBvxwy+V+yA6s+h5yhdDWDrz+koqHXbAZ0x99vE1iA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
psql-ev-sv-support.diff text/plain 19.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2015-05-04 09:22:33 Re: cost_index() and path row estimate.
Previous Message Anton 2015-05-04 08:48:02 Re: [HACKERS] optimization join on random value