proposal or just idea for psql - show first N rows from relation backslash statement - Mailing list 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