Thread: Format

Format

From
Ramesh T
Date:
Hi All,
          How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres.

any help appreciated..

Re: Format

From
"David G. Johnston"
Date:
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@gmail.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..

Re: Format

From
Igor Neyman
Date:

Hi All,

          How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres.

 

any help appreciated..

 

 

Are you looking for SQL editor?

If that’s the case, take a look at contexteditor.org

 

Regards,

Igor Neyman

Re: Format

From
"David G. Johnston"
Date:
On Mon, Sep 28, 2015 at 1:59 PM, Igor Neyman <ineyman@perceptron.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..

 

 

Are you looking for SQL editor?

If that’s the case, take a look at contexteditor.org



​format => alter; all I see in the linked editor is highlighting.​..

David J.

Re: Format

From
"David G. Johnston"
Date:


Not only, there is little of formatting, like TABs.

But, even highlighting helps.



​Since pgAdminIII does highlighting I figured the OP wanted something more...I know what I am looking is more than just highlighting.

David J.
 

Re: Format

From
Igor Neyman
Date:

 

 

From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Monday, September 28, 2015 3:14 PM
To: Igor Neyman <ineyman@perceptron.com>
Cc: Ramesh T <rameshparnanditech@gmail.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Format

 

On Mon, Sep 28, 2015 at 1:59 PM, Igor Neyman <ineyman@perceptron.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..

 

 

Are you looking for SQL editor?

If that’s the case, take a look at contexteditor.org

 

 

​format => alter; all I see in the linked editor is highlighting.​..

 

David J.

 

Not only, there is little of formatting, like TABs.

But, even highlighting helps.

 

Regards,

Igor Neyman

Re: Format

From
Andreas Joseph Krogh
Date:
På mandag 28. september 2015 kl. 14:45:00, skrev Ramesh T <rameshparnanditech@gmail.com>:
Hi All,
          How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres.
 
any help appreciated..
 
Use IntelliJ IDEA community-edition, which is free: https://www.jetbrains.com/idea/download/
 
It is a JAVA-IDE, but the support for PostgreSQL is excellent. It comes with syntax-highligting, code-completion, DB-browser etc.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

Re: Format

From
Ramesh T
Date:


On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T <rameshparnanditech@gmail.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..



On Mon, Sep 28, 2015 at 11:20 PM, David G. Johnston <david.g.johnston@gmail.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@gmail.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..



Re: Format

From
Adrian Klaver
Date:
On 09/29/2015 06:13 AM, Ramesh T wrote:
>
>
> On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T <rameshparnanditech@gmail.com
> <mailto:rameshparnanditech@gmail.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.g.johnston@gmail.com <mailto:david.g.johnston@gmail.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@gmail.com
>         <mailto:rameshparnanditech@gmail.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.klaver@aklaver.com


Re: Format

From
Ramesh T
Date:
Nice, thank you.

On Tue, Sep 29, 2015 at 11:16 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 09/29/2015 06:13 AM, Ramesh T wrote:


On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T <rameshparnanditech@gmail.com
<mailto:rameshparnanditech@gmail.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.g.johnston@gmail.com <mailto:david.g.johnston@gmail.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@gmail.com
        <mailto:rameshparnanditech@gmail.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.klaver@aklaver.com