About CASE Studio - generate SQL output (how to link tablespace to table definition)

Поиск
Список
Период
Сортировка
Искать

About CASE Studio - generate SQL output (how to link tablespace to table definition)

От:
Emi Lu <emilu@encs.concordia.ca>
Дата:
Hello,

Does anybody have the experiences of using "CASE Studio" ?

I used CASE Studio 2.2.1,and it helps me get a global picture of all 
objects we have. I tried to generate SQL outputs for tables' 
definitions. However, I cannot figure out how to specify tablespaces for 
indexes. For example, " ... primary key (***) using tablespace 
fis_index" ,  "unique constraint using tablespace fis_index", etc.

Also, please clue me in how feasible the SQL outputs generated by CASE 
Studio? I mean do you think it can generate what you expect from your 
experiences?

Thanks a lot,
Emi

Re: About CASE Studio - generate SQL output (how to link

От:
Emi Lu <emilu@encs.concordia.ca>
Дата:
I saw the online doc mentioned that it supports tablespace for oracle 
and db2, but does it supports tablespace for postgresql 8.0 as well?

http://www.casestudio.com/enu/ver219.aspx

- Emi

>
> Does anybody have the experiences of using "CASE Studio" ?
>
> I used CASE Studio 2.2.1,and it helps me get a global picture of all 
> objects we have. I tried to generate SQL outputs for tables' 
> definitions. However, I cannot figure out how to specify tablespaces 
> for indexes. For example, " ... primary key (***) using tablespace 
> fis_index" ,  "unique constraint using tablespace fis_index", etc.
>
> Also, please clue me in how feasible the SQL outputs generated by CASE 
> Studio? I mean do you think it can generate what you expect from your 
> experiences?
>
> Thanks a lot,
> Emi
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
FAQ