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

List:       postgresql-general
Subject:    Re: [GENERAL] Postgresql feature
From:       John Sidney-Woollett <johnsw () wardbrook ! com>
Date:       2004-08-18 17:53:39
Message-ID: 412397A3.5030502 () wardbrook ! com
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]