Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: proposal or just idea for psql - show first N rows from relation backslash statement
Date
Msg-id CAFj8pRAZgt__YNxQeVPDReBM5y-HaUX07q1b++Viz-NtcKwJGw@mail.gmail.com
Whole thread Raw
In response to Re: proposal or just idea for psql - show first N rows from relation backslash statement  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view 
2013/2/13 Stephen Frost <sfrost@snowman.net>:
> * Pavel Stehule (pavel.stehule@gmail.com) wrote:
>> and I expect so limit 10 is default
>>
>> table statement is little bit different creature (and mainly it is server side)
>
> I don't really see the value in this.

it is just shortcut for often used query - nothing more

and with larger tables you don't need to forget LIMIT clause

Regards

Pavel

>
>         Thanks,
>
>                 Stephen

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: 9.2.3 crashes during archive recovery
Next
From: Tom Lane
Date:
Subject: Re: proposal or just idea for psql - show first N rows from relation backslash statement