[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Postgresql feature
From:       Ben <bench () silentmedia ! com>
Date:       2004-08-18 18:08:16
Message-ID: Pine.LNX.4.44.0408181106230.14155-100000 () localhost ! localdomain
[Download RAW message or body]

Is it just me, or has there been a rash of "I'm thinking about postgres 
and coming from an oracle background" questions recently? Was there some 
writeup of postgres in a db rag in the last month or so?

On Wed, 18 Aug 2004, John Sidney-Woollett wrote:

> Bit more info (from my own findings migrating from Oracle -> Postgres)
> 
> Sequences - YES
> Packages - NO (concept doesn't exist in PG)
> Functions - YES, Procedures - NO (also no INOUT or OUT parameters)
> Full-text - YES, tSearch2
> Triggers - YES
> Jobs - NO, (but scheduled tasks can be implemented in other ways)
> Synonyms - NO (can be frigged using search_paths and schemas)
> Replication - more than one option depending on requirement
> 
> You will miss certain Oracle features, but once you get into the swing 
> of postgres you'll not look back. Also consider how much money you'll 
> save in license fees!
> 
> John Sidney-Woollett
> 
> Gaetano Mendola wrote:
> 
> > Laimis K wrote:
> > 
> >> Hi,
> >> I'm oracle man.
> >>
> >> So, how about features in postgesql which exists in oracle db (order is
> >> casual) ?
> >> 1. Sequences
> >> 2. Packages
> >> 3. Functions/procedures
> >> 4. Full-text
> >> 5. Triggers
> >> 6. Jobs
> >> 7. Synonyms
> >> 8. Replication
> > 
> > 
> > 1) Serial, but I don't know the Oracle one...
> > 2) Schema ?
> > 3) Yes, functions
> > 4) tsearch2
> > 5) Yes
> > 6) ??
> > 7) ??
> > 8) A couple of solutions
> > 
> > 
> > http://www.postgresql.org/docs/7.4/interactive/index.html
> > 
> > 
> > Regards
> > Gaetano Mendola
> > 
> > 
> > 
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> >               http://www.postgresql.org/docs/faqs/FAQ.html
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
[prev in list] [next in list] [prev in thread] [next in thread]