Tag Archives: postgres

Extending PostgreSQL with Python

One of the features I enjoy the most about PostgreSQL is the ability to write stored procedures in C, Perl, TCL, PgSQL, and yes… obviously also in Python. I’ve been using this feature since 7.4, so any recent version of … Continue reading

Posted in Databases, linux, tech, unix | Tagged , , , , , , | 2 Comments

Fixing custom sequences in PostgreSQL

PostgreSQL provides a mechanism called sequences, which I believe is extracted from ANSI-SQL92, though I’m too lazy to check, which are basically stateful counters that provide some helper functions. The primary use of sequences in PostgreSQL and Oracle, is to … Continue reading

Posted in Databases, linux, tech, unix | Tagged , , , , | Leave a comment