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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: proposal or just idea for psql - show first N rows from relation backslash statement
Дата
Msg-id 16696.1360790719@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: proposal or just idea for psql - show first N rows from relation backslash statement  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: proposal or just idea for psql - show first N rows from relation backslash statement  (Ian Lawrence Barwick <barwick@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Stephen Frost <sfrost@snowman.net> writes:
> * Pavel Stehule (pavel.stehule@gmail.com) wrote:
>> SELECT * FROM some_relation LIMIT 10
>> 
>> what do you thinking about creating special statement for this purpose?

> I'd rather extend TABLE to support a limit clause or something.

Can't you pretty much do this already in psql with FETCH_COUNT?  I see
no good reason to invent more SQL syntax.
        regards, tom lane

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal or just idea for psql - show first N rows from relation backslash statement
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system