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

On Thu, Feb 14, 2013 at 8:43 AM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> * Pavel Stehule (pavel(dot)stehule(at)gmail(dot)com) wrote:
>> My proposal should not replace stored procedures.
>
> Stored procedures, with actual transaction-management capabilities, is a
> completely different topic which isn't usefully involved here.
>
>> The core of my proposal was using autocomplete for one often task.
>
> TABLE already supports tab-completion.

TABLE is fine. My point is that often when discussing extensions to
psql are we really working around lack of stored procedures. Talk of
stored procedures is not off topic, because they could directly
implement proposed $feature in a much more general way. I am very
sanguine about implementation difficulties but please don't shoot the
messenger.

> SELECT top10('foo');

That doesn't work. functions don't allow arbitrary returned columns.
CALL should support this.

Anyways, if we are counting characters,
TA<tab> fo<tab> limit 10; < 17
CA<tab> to<tab>('foo'); < 15 (but different table name could
certainly swing it)

merlin