Re: SQL pretty pritner?

From: "Basques, Bob (CI-StPaul)" <bob(dot)basques(at)ci(dot)stpaul(dot)mn(dot)us>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: SQL pretty pritner?
Date: 2019-10-28 14:46:32
Message-ID: 04BF0F6A-D650-4AE5-9C49-4463C60489BD@ci.stpaul.mn.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All,

VI has a lot of option ( that I haven’t tried) and I would bet that there are options for formatting and page breaks, etc. It’s a bit of a learning curve though.

bobb

> On Oct 28, 2019, at 8:44 AM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
> Think Before You Click: This email originated outside our organization.
>
>
>> On Oct 28, 2019, at 7:37 AM, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>>
>> But does it reformat the text?
>>
> It’s an “indented text mode” so beeline respect current indentation. I don’t think it will take an stream out sql and add newlines at predictable places. Not at My desk to try.
>
>>> On 10/28/19 8:00 AM, Basques, Bob (CI-StPaul) wrote:
>>> All,
>>>
>>> Take a look at the VI(m) editor. There is a Syntax mode for highlighting different file types, as well as tools for exporting the highlighted text to HTML. I have yet to find a file type that it doesn’t already handle.
>>>
>>> Works really slick.
>>>
>>> bobb
>>>
>>>
>>>
>>>>> On Oct 27, 2019, at 5:21 PM, stan <stanb(at)panix(dot)com> wrote:
>>>>
>>>> Think Before You Click: This email originated outside our organization.
>>>>
>>>>
>>>> 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.
>>>>
>>>> Development being done in an Ubuntu Linux environment.
>>>>
>>>> Anyone have a recommendation?
>>>
>>
>> --
>> Angular momentum makes the world go 'round.
>>
>>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Felder 2019-10-28 15:00:12 Re: jsonb_set() strictness considered harmful to data
Previous Message Basques, Bob (CI-StPaul) 2019-10-28 14:27:19 Re: SQL pretty pritner?