| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Ramesh T <rameshparnanditech(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Format |
| Date: | 2015-09-28 17:50:10 |
| Message-ID: | CAKFQuwZMvTQmbP1GRcaxobehBUaEEV32fY5k-KiA29Dgq=-k-w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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>
wrote:
> Hi All,
> How to change sql format to look beautiful and understandable
> using pgadmin3 or else ther tools for postgres.
>
> any help appreciated..
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2015-09-28 17:59:28 | Re: Format |
| Previous Message | Vincent Veyron | 2015-09-28 16:15:55 | Re: error on CREATE INDEX when restoring from dump file: could not read block 0 |