Re: Format

Nice, thank you.

On Tue, Sep 29, 2015 at 11:16 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 09/29/2015 06:13 AM, Ramesh T wrote:
>
>>
>>
>> On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T <rameshparnanditech(at)gmail(dot)com
>> <mailto:rameshparnanditech(at)gmail(dot)com>> wrote:
>>
>> in my mind to be beautiful ,avoid confusion to understand sql query
>> code
>>
>> like
>>
>> select
>> abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ;
>>
>> if some one written, then newer or code reader understand easily
>> select abcd,
>> cde,
>> rfg,
>> count(*),
>> ...,
>> ..,
>> ...,
>> like line by line
>>
>> in postgres direct option format is not available.i want see code
>> intended proper.
>> in context editor i didn't find format option only like lower to
>> upper..
>>
>>
>
> http://sqlformat.darold.net/
>
> To install locally:
> https://github.com/darold/pgFormatter
>
> http://format-sql.de/
>
> To install locally:
> https://github.com/paetzke/format-sql
>
>
>>
>> On Mon, Sep 28, 2015 at 11:20 PM, David G. Johnston
>> <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>>
>> wrote:
>>
>> CREATE FUNCTION
>> CREATE VIEW
>>
>> As yes, I am being mostly serious - though I have been pondering
>> seeing what tools can do as opposed to the manual formatting
>> I've been performing. Even a basic linter would be helpful...
>>
>> The big problem is you need to define what it means to be
>> beautiful. Understandable is a totally different area and that
>> is more where views and functions come in so you can provide
>> names to the various constructs you are using. CTE/WITH
>> facilitate this as well.
>>
>> David J.
>>
>>
>> On Mon, Sep 28, 2015 at 8:45 AM, Ramesh T
>> <rameshparnanditech(at)gmail(dot)com
>> <mailto:rameshparnanditech(at)gmail(dot)com>> wrote:
>>
>> Hi All,
>> How to change sql format to look beautiful and
>> understandable using pgadmin3 or else ther tools for postgres.
>>
>> any help appreciated..
>>
>>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>