Обсуждение: Format
Hi All,
How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres.
any help appreciated..
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..
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
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.
Since pgAdminIII does highlighting I figured the OP wanted something more...I know what I am looking is more than just highlighting.
David J.
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
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
Вложения
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 codelikeselect abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ;if some one written, then newer or code reader understand easilyselect abcd,cde,rfg,count(*),...,..,...,like line by linein 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 FUNCTIONCREATE VIEWAs 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..
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
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