diff options
| author | Robert Haas | 2013-10-03 19:18:02 +0000 |
|---|---|---|
| committer | Robert Haas | 2013-10-03 19:18:02 +0000 |
| commit | c64e68fd9f1132fec563fb5de53dc3bcccb5fc3b (patch) | |
| tree | 9427cfec4bd43e0f2c2a22a39f0cfa07ed47e20c /src/test | |
| parent | c2b175b94851e59765cc87243d8faf923e3d820b (diff) | |
psql: Make \pset without arguments show all settings.
Gilles Darold, reviewed by Pavel Stehule
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/psql.out | 16 | ||||
| -rw-r--r-- | src/test/regress/sql/psql.sql | 3 |
2 files changed, 19 insertions, 0 deletions
diff --git a/src/test/regress/expected/psql.out b/src/test/regress/expected/psql.out index 7dd5c7b51b9..2bbee7df004 100644 --- a/src/test/regress/expected/psql.out +++ b/src/test/regress/expected/psql.out @@ -52,3 +52,19 @@ more than one row returned for \gset select 10 as test01, 20 as test02 from generate_series(1,0) \gset no rows returned for \gset \unset FETCH_COUNT +-- show all pset options +\pset +Border style (border) is 1. +Target width (columns) unset. +Expanded display (expanded) is off. +Field separator (fieldsep) is "|". +Default footer (footer) is on. +Output format (format) is aligned. +Line style (linestyle) is ascii. +Null display (null) is "". +Locale-adjusted numeric output (numericlocale) is off. +Pager (pager) is used for long output. +Record separator (recordsep) is <newline>. +Table attributes (tableattr) unset. +Title (title) unset. +Tuples only (tuples_only) is off. diff --git a/src/test/regress/sql/psql.sql b/src/test/regress/sql/psql.sql index 50ee02a7f79..99ad5b4a70b 100644 --- a/src/test/regress/sql/psql.sql +++ b/src/test/regress/sql/psql.sql @@ -37,3 +37,6 @@ select 10 as test01, 20 as test02 from generate_series(1,3) \gset select 10 as test01, 20 as test02 from generate_series(1,0) \gset \unset FETCH_COUNT + +-- show all pset options +\pset |