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

On Wed, February 13, 2013 21:23, Stephen Frost wrote:
> * 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.
>

No need; that already does work, e.g.:

testdb=# table pg_database limit 3;

Not in the documentation, but I hope it won't get removed -- it's quite handy