PostgreSQL – Functions PostgreSQL functions, also known as Stored Procedures, allow you to carry out operations that would normally take several queries and round trips in a single function within the database. Functions allow database reuse as other applications can interact directly with your stored procedures instead of a middle-tier or duplicating code. Functions can […]
Category Archives: postgresql
PostgreSQL – Useful Functions PostgreSQL built-in functions, also called as Aggregate functions, are used for performing processing on string or numeric data. The following is the list of all general-purpose PostgreSQL built-in functions − − The PostgreSQL COUNT aggregate function is used to count the number of rows in a database table. − The PostgreSQL […]
PostgreSQL – Perl Interface Installation The PostgreSQL can be integrated with Perl using Perl DBI module, which is a database access module for the Perl programming language. It defines a set of methods, variables and conventions that provide a standard database interface. Here are simple steps to install DBI module on your Linux/Unix machine − […]