Leo Hsu and Regina Obe
PostgreSQL Array: The ANY and Contains trick
Build-in PostgreSQL arrays support: using array elements as comma separated items in an SQL ANY clause and using arrays in column definitions and with Contains operator.
PostgreSQL Array: The ANY and Contains trick
Build-in PostgreSQL arrays support: using array elements as comma separated items in an SQL ANY clause and using arrays in column definitions and with Contains operator.
Leo Hsu and Regina Obe
Encrypting PostgreSQL data with pgcrypto
In this article we'll go over the basics built-in and the more advanced provided by the PostgreSQL contrib module pgcrypto.
Encrypting PostgreSQL data with pgcrypto
In this article we'll go over the basics built-in and the more advanced provided by the PostgreSQL contrib module pgcrypto.
Leo Hsu and Regina Obe
Regular Expressions in PostgreSQL
This article highlights the methods of using regular expressions in PostgreSQL SQL statements.
Regular Expressions in PostgreSQL
This article highlights the methods of using regular expressions in PostgreSQL SQL statements.
Adrian Nida
PostgreSQL Authenication with pam_ldap
This article will discuss how to setup PostgreSQL to authenticate against an LDAP system.
PostgreSQL Authenication with pam_ldap
This article will discuss how to setup PostgreSQL to authenticate against an LDAP system.
Bruce Momjian
SQL Constraints With PostgreSQL
This article has covered a variety of constraints that help restrict user data within specified limits.
SQL Constraints With PostgreSQL
This article has covered a variety of constraints that help restrict user data within specified limits.
Paragon Corporation
Using PostgreSQL User-Defined Functions to solve the Tree Problem
In this article we demonstrate how to solve the classic tree problem using PostGreSQL user-defined functions.
Using PostgreSQL User-Defined Functions to solve the Tree Problem
In this article we demonstrate how to solve the classic tree problem using PostGreSQL user-defined functions.