Is there a good tutorial or something similar for learning how to write Stored Procedures (for a PostgreSQL database). I'm a definite newbie when it comes to writing Stored Procedures at all, so the clearer and simpler things are explained, the better...
Thanks in advance...
If you have some prior experience in designing and building databases, one to two weeks of dedication should be sufficient to master the concepts of PostgreSQL. If not, you can expect a time of two to three weeks to cover the topics in all its depth.
PostgreSQL does not support stored procedures in the sense that a database such as Oracle does, but it does support stored functions.
PostgreSQL has very exhaustive and detailed documentation. Although tough on the beginner – it is hard to find an easy entry point – having mastered the first step, you will never run out of information to further your knowledge.
You almost had it, but better start here plpgsql
Some will point that PL/pgSQL
is not the only way to write Stored Procedures for PostgreSQL and they will be right (that's one of the advantages of Postgres), but on the other hand PL/pgSQL
is nice and relatively easy to start with.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With