Re: Best practice in postgres

Oracle and PostgreSQL schemas seem to have fairly equivalent functionality
from what I've read, except that PostgreSQL schemas aren't as tied to a
particular user as are Oracle's.



   
                      Robert Treat
   
                      <xzilla@users.sourcefor        To:       Nilesh Doshi <nileshd@hotmail.com>
   
                      ge.net>                        cc:       "pgsql-general@postgresql.org"
   
                      Sent by:                        <pgsql-general@postgresql.org>
   
                      pgsql-general-owner@pos        Subject:  Re: [GENERAL] Best practice in postgres
   
                      tgresql.org
   

   

   
                      12/14/2004 09:29 AM
   

   

   




On Fri, 2004-12-10 at 17:49, Nilesh Doshi wrote:
> Hi All,
>
> I'm new to postgres, so I need your help.
>
> We are in the process of migrating from oracle to postgres. DB size is
about
> 400gb.
> My question is about schemas in oracle and postgres. Does every schema in

> oracle becomes a separate database in postgres ? OR it is still like
oracle,
> where all schemas are part of big database ?
>

I'm pretty sure you want schema -> schema and not schema -> database,
mainly because the semantics for querying across databases are much more
cumbersome than querying across schemas.  If you are not doing any cross
schema work, then it probably doesn't matter as much.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html