469,313 Members | 2,584 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

Postgresql feature

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
Thanks
Nov 23 '05 #1
10 1466
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/i...ive/index.html
Regards
Gaetano Mendola


Nov 23 '05 #2
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/i...ive/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 ma*******@postgresql.org

Nov 23 '05 #3
Ben
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/i...ive/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 ma*******@postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #4

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/i...ive/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
ma*******@postgresql.org


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

Nov 23 '05 #5
On Wed, 18 Aug 2004 14:29:03 -0400 Andrew Rawnsley <ro**@ravensfield.com> 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.


the size of the frigging download is enough to honk nearly
anyone off.

the thing is what, two orders of magnitude bigger than all of
PostgreSQL?

richard
--
Richard Welty rw****@averillpark.net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #6
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)


You can create a schema to put all your functions/procedures in it and provide
access control to it.

I think it is good enough emulation of packages barring compiling them to detect
errors in pl/sql code.

This has been mentioned before and few people reported it to be good enough
workaround..

HTH

Shridhar

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #7
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/i...ive/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
ma*******@postgresql.org


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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #8
On Wed, 2004-08-18 at 13:53, John Sidney-Woollett wrote:
Bit more info (from my own findings migrating from Oracle -> Postgres)
Jobs - NO, (but scheduled tasks can be implemented in other ways)


There is a project on gborg (or maybe pgfoundry) called pgjobs which
aims to create an oracle like task schedular in postgresql. not sure how
mature it is but might be worth a look for those interested in this.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #9
Main features which Oracle have and postgresql no (for me):
- object dependency - when I change any object (view, function ..) in postgresql I have to delete all dependencies
objects - Oracle auto compile all dependencies
- distributed databases - all dml, ddl, connect etc work in distributed systems
- true cursor managment - all oracle command are cursor (parse, bind, fetch arbitary numebr of rows)
- select out of transaction managment (select withoout mutable functions - don't update in database)

regards
On Wednesday 18 August 2004 02:41 pm, 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/i...ive/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 8: explain analyze is your friend

Nov 23 '05 #10
On Wed, 2004-08-18 at 05:06, 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


Might want to check the postgresql documentation. ;-)

-Robby

--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | ro***@planetargon.com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
****************************************/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQBBJUpB0QaQZBaqXgwRAgleAJ4+DysACPCqH8IX675qQe TcSVLhNACguDQF
ov4mJ5BcnWexqeGar10FG04=
=nyiG
-----END PGP SIGNATURE-----

Nov 23 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Google Mike | last post: by
1 post views Thread by Mateusz [PEYN] Adamus | last post: by
7 posts views Thread by Alex Page | last post: by
59 posts views Thread by Jeff Bowden | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.