]> granicus.if.org Git - postgresql/commit
Create a FETCH_COUNT parameter that causes psql to execute SELECT-like
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 29 Aug 2006 22:25:08 +0000 (22:25 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 29 Aug 2006 22:25:08 +0000 (22:25 +0000)
commitc2f60711d25b256dbe2c1ddce833c5c69ca051cc
tree37f805b925c2d8827d27e9930351cf778fdc9afb
parent7c5ac5ce2234688a1048d4c26d9fa7cabeaa004f
Create a FETCH_COUNT parameter that causes psql to execute SELECT-like
queries via a cursor, fetching a limited number of rows at a time and
therefore not risking exhausting memory.  A disadvantage of the scheme
is that 'aligned' output mode will align each group of rows independently
leading to odd-looking output, but all the other output formats work
reasonably well.  Chris Mair, with some additional hacking by moi.
doc/src/sgml/ref/psql-ref.sgml
src/bin/psql/common.c
src/bin/psql/print.c
src/bin/psql/print.h
src/bin/psql/settings.h
src/bin/psql/startup.c