Re: Database structure

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