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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: proposal or just idea for psql - show first N rows from relation backslash statement
Date: 2013-02-13 20:07:54
Message-ID: CAFj8pRCeE5TzW-2WcCHpJtf1CbPQ4E_PauLW1x9QS7MWgxn-Pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

probably one from my top ten SQL statement will be

SELECT * FROM some_relation LIMIT 10

what do you thinking about creating special statement for this purpose?

possible syntax

-- ViewTable
\vt table_name [rows]

or

\sample table_name [rows]

a implementation with autocomplete is terrible simple

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2013-02-13 20:15:03 Re: 9.2.3 crashes during archive recovery
Previous Message Tom Lane 2013-02-13 19:40:23 Re: 9.2.3 crashes during archive recovery