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

2013/2/14 Stephen Frost <sfrost@snowman.net>:
> * Pavel Stehule (pavel.stehule@gmail.com) wrote:
>> it is not true
>
> It most certainly is true- did you look at the command?
>
> SELECT top10('foo');
>
> Note that it's "top10", implying that it'd return the first 10 records.
> That's only 2 characters more than:

In current implementation you need a a polymorphic function

and then you have to write

SELECT (top10('foo')).*

or

SELECT * FROM top10('foo')

Regards

Pavel

>
> CALL top10('foo');
>
> It's not as short as '\vt foo', but I never claimed that it was, nor do
> I feel it's particularly valuable to shorten it down to that level.
>
>         Thanks,
>
>                 Stephen