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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, fabriziomello(at)gmail(dot)com, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal or just idea for psql - show first N rows from relation backslash statement
Date: 2013-02-14 16:49:53
Message-ID: 23156.1360860593@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> This discussion isn't going to change my feelings on this particular
> misfeature. If others feel it's valuable and important then they can
> certainly speak-up.

I think the same --- a new backslash command for this is absolutely not
worth its weight compared to using "TABLE foo".

We have identified at least two places where psql could be improved to
support the use of "TABLE foo" better, without adding any new syntax
(viz, teach the FETCH_COUNT logic about it and improve tab-completion
to know about the possibility of limit/offset clauses). I think that's
a much more sensible path to pursue than inventing more "features".

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-02-14 16:55:35 Re: [RFC] pgstattuple/pgstatindex enhancement
Previous Message Peter Eisentraut 2013-02-14 16:45:53 Re: BUG #7493: Postmaster messages unreadable in a Windows console