Re: [GENERAL] sql formatter/beautifier

2007-03-08 Thread Joris Dobbelsteen
e was nice: http://psti.equinoxbase.com/cgi-bin/handler.pl - Joris >-Original Message- >From: Aaron Bingham [mailto:[EMAIL PROTECTED] >Sent: donderdag 8 maart 2007 11:36 >To: Joris Dobbelsteen >Cc: Merlin Moncure; postgres general >Subject: Re: [GENERAL] sql format

Re: [GENERAL] sql formatter/beautifier

2007-03-08 Thread Aaron Bingham
Joris Dobbelsteen wrote: PostGreSQL (7.4 and onward) has such a thing build-in, but its not particulary good (simple case works, but once it gets complex it makes a mess out of it). Hi, Cleaning out my pgsql-general mail, I ran across your post. How do I invoke PostgreSQL's built-in SQL beaut

Re: [GENERAL] sql formatter/beautifier

2007-02-03 Thread Joris Dobbelsteen
PostGreSQL (7.4 and onward) has such a thing build-in, but its not particulary good (simple case works, but once it gets complex it makes a mess out of it). For example the postgresql formatted version $CREATE OR REPLACE VIEW "Subquery" AS $ SELECT t1.a, t2.b $ FROM ( SELECT 1 AS a, 2 AS x) t1