>From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx> >On 10/27/19 3:21 PM, stan wrote: >> I have a presentation later in the week, and i plan on printing out >> some files containing SQL commands. I have used some "pretty printers" >> in the past for things like Perl scripts. What I am thinking of s >> something that bolds keywords, handles page breaks, and does some formatting. > >http://sqlformat.darold.net/ > >https://sourceforge.net/projects/pgformatter/ If I had that task, I'd use a combo of tools. "pgFormatter" that Adrian shows above is what you use to reformat to make it aligned nicely, plus it does some colorization. The first link is the online tool; the 2nd link is if you want to download the code to your own server. Example: select count(*) from tablea where x is null; Result: SELECT count(*) FROM tablea WHERE x IS NULL; You can't see it here, but all the keywords are bold and colored, and "count" is colored but not bolded. If that colorization isn't good enough for you, then as others have said, paste the result into "vim" to get the colorization, pasting that into PowerPoint/Word or something that honors the colors...or just take a screen shot of that...or whatever works for you. HTH, Kevin This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.
