psql: Missing option to print current buffer to current output channel (i.e., \qprint) - Mailing list pgsql-hackers

From David G. Johnston
Subject psql: Missing option to print current buffer to current output channel (i.e., \qprint)
Date
Msg-id CAKFQuwZAm9WXpY+=iBvQUgALCtAP1VA6sT6eRRWg4r_MmWLm=g@mail.gmail.com
Whole thread Raw
List pgsql-hackers
<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">"\echo" has "\qecho" - I'm
basicallylooking for a "\qprint"</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br
/></div><divclass="gmail_default" style="font-family:arial,helvetica,sans-serif">"\write" doesn't apply</div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif"><br /></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">Thefollowing doesn't work either...</div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><br/></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">#bash(stock Ubuntu 14.04)</div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">psql--set=query_in_var='SELECT version();' > /dev/null
<<'SQL'</div><divclass="gmail_default" style="font-family:arial,helvetica,sans-serif">\o
/tmp/psql-test.txt</div><divclass="gmail_default" style="font-family:arial,helvetica,sans-serif">\set ECHO
queries</div><divclass="gmail_default" style="font-family:arial,helvetica,sans-serif">--still ends up on stdout, hence
theredirect to /dev/null to avoid it showing on screen along with the cat output below </div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">:query_in_var</div><divclass="gmail_default"
style="font-family:arial,helvetica,sans-serif">\o</div><divclass="gmail_default"
style="font-family:arial,helvetica,sans-serif">SQL</div><divclass="gmail_default"
style="font-family:arial,helvetica,sans-serif">cat/tmp/psql-test.txt</div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><br/></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">Cananyone offer a reason not to add "\qprint"?</div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif"><br /></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">DavidJ.</div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><br/></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><br/></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><br/></div></div> 

pgsql-hackers by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Heap WARM Tuples - Design Draft
Next
From: Greg Stark
Date:
Subject: Pgbench performance tuning?