Re: [HACKERS] selecting large result sets in psql using

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-patches(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, Chris Mair <chrisnospam(at)1006(dot)org>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [HACKERS] selecting large result sets in psql using
Date: 2006-08-18 12:35:13
Message-ID: 200608181435.14446.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Am Donnerstag, 17. August 2006 20:05 schrieb Chris Mair:
> \gc sounds like a good idea to me :)

Strictly speaking, in the randomly defined grammer of psql, \gc is \g with an
argument of 'c' (try it, it works).

I'm not sure what use case you envision for this feature. Obviously, this is
for queries with large result sets. I'd guess that people will not normally
look at those result sets interactively. If the target audience is instead
psql scripting, you don't really need the most convenient command possible.
A \set variable would make sense to me.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-08-18 12:46:39 Re: Going for "all green" buildfarm results
Previous Message Magnus Hagander 2006-08-18 12:33:58 Re: Bug with initDB under windows 2003

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2006-08-18 12:46:39 Re: Going for "all green" buildfarm results
Previous Message Magnus Hagander 2006-08-18 11:49:06 Re: pg_regress in C