Re: Database structure

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Database structure
Дата
Msg-id web-1455105@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Database structure  ("Peter Goggin" <pgoggin@smartchat.net.au>)
Список pgsql-novice
Peter,

> I have had a number of years experience with Oracle.  I am
> considering using Postgresql but while there is an enourmous amount
> of documentation available, none of it seems to answer some questions
> which I have to resolve if I am to use it.

Make sure you've looked at http://techdocs.postgresql.org/
There are several Oracle porting guides there.

> 1. Does postgresql have the concept of table spaces as used in
> Oracle?

If you mean Schema, not yet.  If you mean temporary tables, yes.
 Otherwise, no.  As far as I know, Oracle's "table space" construction
is not part of the SQL 92 or 99 standard.

> 2. Is it possible to construct the data base so that the index for a
> table can reside on a different disk to the data for the table?

Not practically.  It can be done, but it would be an annoyance to
maintain.  I'm curious about why someone would need this.

> 3. Is there an interface for postgresql which can be used to link the
> data base to web pages?

I'm sorry, you'll have to be more specific.

-Josh Berkus


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Peter Goggin"
Дата:
Сообщение: Database Structure
Следующее
От: "Henshall, Stuart - WCP"
Дата:
Сообщение: Re: Database structure