psql: Missing option to print current buffer to current output channel (i.e., \qprint)
| От | David G. Johnston |
|---|---|
| Тема | psql: Missing option to print current buffer to current output channel (i.e., \qprint) |
| Дата | |
| Msg-id | CAKFQuwZAm9WXpY+=iBvQUgALCtAP1VA6sT6eRRWg4r_MmWLm=g@mail.gmail.com обсуждение исходный текст |
| Список | 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 по дате отправления: