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

From Erik Rijkers
Subject Re: proposal or just idea for psql - show first N rows from relation backslash statement
Date
Msg-id 2417d015e66a3a7921d385aecfd0f57c.squirrel@webmail.xs4all.nl
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
List pgsql-hackers
On Wed, February 13, 2013 21:23, Stephen Frost wrote:
> * 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.
>

No need; that already does work, e.g.:

testdb=# table pg_database limit 3;

Not in the documentation, but I hope it won't get removed -- it's quite handy






pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Alias hstore's ? to ~ so that it works with JDBC
Next
From: Stephen Frost
Date:
Subject: Re: proposal or just idea for psql - show first N rows from relation backslash statement