Thread: 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

For 1 & 2 I believe you have to use symbolic links
(the names of the files are the OIDs, there's a
contrib module called something like oid2name).
If you mean for Administring it, I believe there is
phppgadmin, and I've also heard that webmin supports it.
regards,
- Stuart

-----Original Message-----
From: Peter Goggin [mailto:pgoggin@smartchat.net.au]
Sent: 09 May 2002 15:11
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Database structure


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.

1. Does postgresql have the concept of table spaces as used in Oracle?
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?
3. Is there an interface for postgresql which can be used to link the data
base to web pages?



Regards



Peter Goggin----

Keep in mind that at least in the docs that I've read, symlinks are quoted
as being the most expensive object to work with. This is probably only an
issue for when the lookup isn't already cached by your operating system.

Joshua b. Jore
http://www.greentechnologist.org

On Thu, 9 May 2002, Henshall, Stuart - WCP wrote:

> For 1 & 2 I believe you have to use symbolic links
> (the names of the files are the OIDs, there's a
> contrib module called something like oid2name).
> If you mean for Administring it, I believe there is
> phppgadmin, and I've also heard that webmin supports it.
> regards,
> - Stuart
>
> -----Original Message-----
> From: Peter Goggin [mailto:pgoggin@smartchat.net.au]
> Sent: 09 May 2002 15:11
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] Database structure
>
>
> 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.
>
> 1. Does postgresql have the concept of table spaces as used in Oracle?
> 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?
> 3. Is there an interface for postgresql which can be used to link the data
> base to web pages?
>
>
>
> Regards
>
>
>
> Peter Goggin----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>