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

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: "Stephen Frost" <sfrost(at)snowman(dot)net>
Cc: "Pavel Stehule" <pavel(dot)stehule(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-13 20:41:59
Message-ID: 2417d015e66a3a7921d385aecfd0f57c.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, February 13, 2013 21:23, Stephen Frost wrote:
> * Pavel Stehule (pavel(dot)stehule(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

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