Re: [PATCHES] selecting large result sets in psql using - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] selecting large result sets in psql using
Date
Msg-id 200608190452.k7J4qhY08256@momjian.us
Whole thread Raw
In response to Re: [PATCHES] selecting large result sets in psql using  (David Fetter <david@fetter.org>)
Responses Re: [PATCHES] selecting large result sets in psql using
List pgsql-hackers
David Fetter wrote:
> On Fri, Aug 18, 2006 at 10:16:12AM -0400, Tom Lane wrote:
> > Peter Eisentraut <peter_e@gmx.net> writes:
> > > A \set variable would make sense to me.
> > 
> > So Peter and Bruce like a \set variable, Chris and I like a
> > different command.  Seems like a tie ... more votes out there
> > anywhere?
> 
> It seems to me that a \set variable lets people use minimal
> intrusiveness on scripts, etc., as they'll just set it when they start
> needing cursor-ized result sets and unset it when finished.

True.  They could even put it in .psqlrc if they want.  Basically need a
way to modify \g.  Seems a \set is the way we have always done such
modifications in the past.  The big question is whether this is somehow
different.  Personally, I don't think so.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: [PATCHES] Information_schema fixes for sequences and temporary tables
Next
From: Bruce Momjian
Date:
Subject: Re: Windows 2000 Support