From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Merlin Moncure <mmoncure(at)gmail(dot)com>, fabriziomello(at)gmail(dot)com, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: proposal or just idea for psql - show first N rows from relation backslash statement |
Date: | 2013-02-14 15:34:42 |
Message-ID: | 20130214153442.GD4747@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Pavel Stehule escribió:
> 2013/2/14 Stephen Frost <sfrost(at)snowman(dot)net>:
> > * Merlin Moncure (mmoncure(at)gmail(dot)com) wrote:
> >> CALL top10('foo');
> >>
> >> which seems more general and just as terse. So I think implementing
> >> call syntax is probably topping my 'wanted feature' list.
> >
> > We have that, it's called 'SELECT' and it's only 2 more characters..
>
> it is not true
>
> SELECT * FROM foo LIMIT 10 -- 26 chars
>
> CALL top('foo') -- 15 chars
>
> \vt foo -- 7 chars
table foo limit 10; -- can be ta<tab>, saves 4 keystrokes
Needs autocompletion for "limit", then it's 8 keystrokes plus table
name, no extraneous features needed.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Jehan-Guillaume de Rorthais | 2013-02-14 15:45:42 | Unarchived WALs deleted after crash |
Previous Message | Stephen Frost | 2013-02-14 14:43:34 | Re: proposal or just idea for psql - show first N rows from relation backslash statement |