summaryrefslogtreecommitdiff
path: root/contrib/dblink/expected
diff options
context:
space:
mode:
authorTom Lane2009-11-22 05:20:41 +0000
committerTom Lane2009-11-22 05:20:41 +0000
commit1753337cf5d0aa5ba04b29ded65b824d9cf12c00 (patch)
treeadefbd23fd367d32f374e9ef9188b4ef37d47820 /contrib/dblink/expected
parent93d3bac5648bddfe195a9cecc45ef0a2da5e85a8 (diff)
Improve psql's tabular display of wrapped-around data by inserting markers
in the formerly-always-blank columns just to left and right of the data. Different marking is used for a line break caused by a newline in the data than for a straight wraparound. A newline break is signaled by a "+" in the right margin column in ASCII mode, or a carriage return arrow in UNICODE mode. Wraparound is signaled by a dot in the right margin as well as the following left margin in ASCII mode, or an ellipsis symbol in the same places in UNICODE mode. "\pset linestyle old-ascii" is added to make the previous behavior available if anyone really wants it. In passing, this commit also cleans up a few regression test files that had unintended spacing differences from the current actual output. Roger Leigh, reviewed by Gabrielle Roth and other members of PDXPUG.
Diffstat (limited to 'contrib/dblink/expected')
-rw-r--r--contrib/dblink/expected/dblink.out20
1 files changed, 10 insertions, 10 deletions
diff --git a/contrib/dblink/expected/dblink.out b/contrib/dblink/expected/dblink.out
index 13e4a6fb4c4..d39aa45373a 100644
--- a/contrib/dblink/expected/dblink.out
+++ b/contrib/dblink/expected/dblink.out
@@ -829,51 +829,51 @@ DROP SERVER fdtest;
DROP FOREIGN DATA WRAPPER postgresql;
-- test asynchronous notifications
SELECT dblink_connect('dbname=contrib_regression');
- dblink_connect
+ dblink_connect
----------------
OK
(1 row)
--should return listen
SELECT dblink_exec('LISTEN regression');
- dblink_exec
+ dblink_exec
-------------
LISTEN
(1 row)
--should return listen
SELECT dblink_exec('LISTEN foobar');
- dblink_exec
+ dblink_exec
-------------
LISTEN
(1 row)
SELECT dblink_exec('NOTIFY regression');
- dblink_exec
+ dblink_exec
-------------
NOTIFY
(1 row)
SELECT dblink_exec('NOTIFY foobar');
- dblink_exec
+ dblink_exec
-------------
NOTIFY
(1 row)
SELECT notify_name, be_pid = (select t.be_pid from dblink('select pg_backend_pid()') as t(be_pid int)) AS is_self_notify, extra from dblink_get_notify();
- notify_name | is_self_notify | extra
+ notify_name | is_self_notify | extra
-------------+----------------+-------
- regression | t |
- foobar | t |
+ regression | t |
+ foobar | t |
(2 rows)
SELECT * from dblink_get_notify();
- notify_name | be_pid | extra
+ notify_name | be_pid | extra
-------------+--------+-------
(0 rows)
SELECT dblink_disconnect();
- dblink_disconnect
+ dblink_disconnect
-------------------
OK
(1 row)