Skip site navigation (1) Skip section navigation (2)

Re: How can I configure the postgresql odbc to return 1 row

From: Marko Ristola <marko(dot)ristola(at)kolumbus(dot)fi>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: How can I configure the postgresql odbc to return 1 row
Date: 2005-04-11 18:18:48
Message-ID: 425ABF88.7040709@kolumbus.fi (view raw or flat)
Thread:
Lists: pgsql-odbc
You can use in the odbc.ini configuration the following
definitions:

Fetch = 2048
UseDeclareFetch = 1

"Fetch" defines the number of rows to fetch at a time.
UseDeclareFetch activates the feature.

Regards,
Marko Ristola

Jeff Eckermann wrote:

>--- Jerry Lam <jlam(at)sandvine(dot)com> wrote:
>  
>
>>Hi,
>>
>>Is it possible to ask postgresql odbc driver to
>>fetch the resulsets from the table one at a time
>>instead of fetching all millions rows into memory?
>>    
>>
>
>Perhaps setting the "Use declare/fetch" driver option
>to true will help you.  This will cause a server side
>cursor to be used, which will return the rows in
>blocks.  What controls the size of the blocks, I have
>no idea; I've never messed with that.
>
>  
>
>>Thank you,
>>
>>Jerry
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faq
>>
>>    
>>
>
>
>		
>__________________________________ 
>Do you Yahoo!? 
>Yahoo! Small Business - Try our new resources site!
>http://smallbusiness.yahoo.com/resources/
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly
>  
>


In response to

pgsql-odbc by date

Next:From: lothar.behrensDate: 2005-04-12 12:19:17
Subject: bytea question
Previous:From: Marko RistolaDate: 2005-04-11 17:06:32
Subject: Re: Driver uses always UTF-8?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group