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

From Merlin Moncure
Subject Re: proposal or just idea for psql - show first N rows from relation backslash statement
Date
Msg-id CAHyXU0xp_9BhwjkW0cYLToMAr9_4wB=C42YOsGrpH2ag7gayxw@mail.gmail.com
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>)
List pgsql-hackers
On Thu, Feb 14, 2013 at 10:03 AM, Stephen Frost <sfrost@snowman.net> wrote:
> * Merlin Moncure (mmoncure@gmail.com) wrote:
>> That doesn't work.  functions don't allow arbitrary returned columns.
>> CALL should support this.
>
> That's yet another discussion, though for a preview, you could just
> return a single text column from the function in which you do whatever
> formatting you want.

sure -- I use this technique often although lately i've moved from
text to hstore/json.

merlin



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: proposal or just idea for psql - show first N rows from relation backslash statement
Next
From: Josh Berkus
Date:
Subject: Call for Google Summer of Code mentors, admins