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
>