| From: | Vlad <marchenko(at)gmail(dot)com> |
|---|---|
| To: | Mark Borins <mark(dot)borins(at)rigadev(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, rickb(at)rigadev(dot)com |
| Subject: | Re: Data Modelling Tools |
| Date: | 2005-05-10 13:58:38 |
| Message-ID: | cd70c68105051006584198a164@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-05-10 14:00:57 | Re: Need input on postgres used for phpBB |
| Previous Message | Tom Lane | 2005-05-10 13:53:18 | Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL |