pgsql: Align better test output regex with grammar in pg_dump TAPtests

Align better test output regex with grammar in pg_dump TAP tests

This enforces one-or-more character matches in the regular expressions
for pg_dump testing on SQL syntax output where zero-or-more matches
implies a syntax error.

Author: Daniel Gustafsson
Reviewed-by: David G. Johnston, Michael Paquier
Discussion: https://postgr.es/m/B313C32C-0E24-4AFB-95FF-6DA0C4E18A89@yesql.se

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f339a998ffe6fb8aa8c114a33316e97b56cb1513

Modified Files
--------------
src/bin/pg_dump/t/002_pg_dump.pl | 46 ++++++++++++++++++++--------------------
1 file changed, 23 insertions(+), 23 deletions(-)