Re: Feature request : Reindentation of code

2010/3/2 Dave Page <dpage@pgadmin.org>:
> On Tue, Mar 2, 2010 at 5:32 PM, Cousin Florence <fcousin@sopragroup.com> wrote:
>> Hi,
>>
>> It would be very nice to have a tool to reindent SQL queries.
>> Indeed, at work, me and my colleague often have to work on queries that
>> we extract from Java code or PL/pgSQL, in order to modify or study them.
>> Most of the time, these queries are not indented, and they are often
>> very complicated. So we have to manually indent them, and that can be
>> very boring and time consuming.
>> Some complain that proprietary tools have this feature, and not pgadmin
>> III.
>
> That might make a nice GSoC project...

pg core has 2/3 components for this task - parser and serialisation.
It missing only some rules for pretty printing. It cold be a good
contrib module (with a few hooks).

Pavel

>
>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>