Re: proposal or just idea for psql - show first N rows from relation backslash statement

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: proposal or just idea for psql - show first N rows from relation backslash statement
Дата
Msg-id 20130214153442.GD4747@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: proposal or just idea for psql - show first N rows from relation backslash statement  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Pavel Stehule escribió:
> 2013/2/14 Stephen Frost <sfrost@snowman.net>:
> > * Merlin Moncure (mmoncure@gmail.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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: proposal or just idea for psql - show first N rows from relation backslash statement
Следующее
От: Jehan-Guillaume de Rorthais
Дата:
Сообщение: Unarchived WALs deleted after crash