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 […]
Category Archives: 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 − […]
PostgreSQL – JAVA Interface Installation Before we start using PostgreSQL in our Java programs, we need to make sure that we have PostgreSQL JDBC and Java set up on the machine. You can check Java tutorial for Java installation on your machine. Now let us check how to set up PostgreSQL JDBC driver. Download the […]