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 [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])