diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-08-29 22:25:08 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-08-29 22:25:08 +0000 |
commit | c2f60711d25b256dbe2c1ddce833c5c69ca051cc (patch) | |
tree | 37f805b925c2d8827d27e9930351cf778fdc9afb /src/bin/psql/settings.h | |
parent | 7c5ac5ce2234688a1048d4c26d9fa7cabeaa004f (diff) |
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.
Diffstat (limited to 'src/bin/psql/settings.h')
-rw-r--r-- | src/bin/psql/settings.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/bin/psql/settings.h b/src/bin/psql/settings.h index 9dc41e3bdfb..3e34f93b955 100644 --- a/src/bin/psql/settings.h +++ b/src/bin/psql/settings.h @@ -3,7 +3,7 @@ * * Copyright (c) 2000-2006, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/bin/psql/settings.h,v 1.29 2006/08/29 15:19:51 tgl Exp $ + * $PostgreSQL: pgsql/src/bin/psql/settings.h,v 1.30 2006/08/29 22:25:07 tgl Exp $ */ #ifndef SETTINGS_H #define SETTINGS_H @@ -96,6 +96,7 @@ typedef struct _psqlSettings bool quiet; bool singleline; bool singlestep; + int fetch_count; PSQL_ECHO echo; PSQL_ECHO_HIDDEN echo_hidden; PSQL_ERROR_ROLLBACK on_error_rollback; |