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 Tom Lane
Subject Re: proposal or just idea for psql - show first N rows from relation backslash statement
Date
Msg-id 16696.1360790719@sss.pgh.pa.us
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>)
Responses Re: proposal or just idea for psql - show first N rows from relation backslash statement  (Ian Lawrence Barwick <barwick@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal or just idea for psql - show first N rows from relation backslash statement
Next
From: Alvaro Herrera
Date:
Subject: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system