> For example, this tool doesn't realize that in postgres you can't add a
> column and set not null in one ALTER TABLE statement. So we are forced to
> manually comb through the SQL scripts it creates and fix the buggy
> statements.

AFAIK started from version 8 it can be combined into single alter statement.

speaking of visual tools - does anyone know a tool to "pretty" SQL
statement (ala "tidy")? Sometimes we have to dig thruogh
auto-generated SQL queries 30k-60k size, which is quite hard to do
when it's one row w/o any indents and line breaks.

--
Vlad

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings