> 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
