Amen to that. I have to use Oracle at work, but I use PostgreSQL for
all my side stuff. Man do I ever miss psql when I'm in SQL*Plus...
On Aug 18, 2004, at 12:29 PM, Andrew Rawnsley wrote:
>
> If you use it enough, I think it is inevitable that something,
> sometime, somewhere will really honk you
> off about Oracle. With the feature bloat they're into these days, very
> likely it will be something
> you care nothing about that does it, too.
>
> On Aug 18, 2004, at 2:08 PM, Ben wrote:
>
>> 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: majo...@postgresql.org]
>>>
>>
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to
>> [email protected: majo...@postgresql.org])
>>
> --------------------
>
> Andrew Rawnsley
> President
> The Ravensfield Digital Resource Group, Ltd.
> (740) 587-0114
> www.ravensfield.com
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
Highlight