Book Image

PostgreSQL Server Programming

Book Image

PostgreSQL Server Programming

Overview of this book

Table of Contents (21 chapters)
PostgreSQL Server Programming Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Summary


The powerful, yet clean, Tcl language is available in PostgreSQL as PL/Tcl and the untrusted PL/Tclu. Both the languages use different Tcl interpreters. PL/Tclu is the oldest language used in PostgreSQL, to access things outside the database. It allows you to write stored procedures in Tcl and takes advantage of all the cool features that Tcl has to offer. You can do almost everything you can with other PL languages, including database access and writing triggers. The only major disadvantage of PL/Tcl is that it does not allow you to return composite types and sets from a function.

In the next chapter, we will explore how to publish your code as a PostgreSQL extension.