Skip site navigation (1) Skip section navigation (2)

feature request: expose sql formatter

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: feature request: expose sql formatter
Date: 2007-02-06 16:10:25
Message-ID: b42b73150702060810y1cd7fa69ie464fdf107764f08@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
hello all, I have a pie in the sky feature request here.  I've been
looking around for a sql 'beautifier' so that all our ddl which is
stored in .sql files can be cleaned up.  pgadmin has a much better
formatter than the gook emitted by pg_dump...

couple of questions here:
* would it be possible to call pgadmin with a switch from the command
line so it formats an sql file and exits?

pgadmin -f foo.sql > foo_formatted.sql

* the default options are pretty good, but what about improving the
flexibility a bit (for example, sql keywords upper/lower case)?  this
would benefit everybody imo.

if you guys are open this, could somebody give some hints about the complexity?

merlin

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2007-02-06 20:39:44
Subject: Re: feature request: expose sql formatter
Previous:From: svnDate: 2007-02-06 15:12:49
Subject: SVN Commit by dpage: r5908 - trunk/pgadmin3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group