To learn PostgreSQL, you must have a basic understanding of SQL that contains queries like SELECT, INSERT, and UPDATE, etc. By knowing the usage of relational databases, it …

This chapter explains various methods of accessing the database. Assume that we have already created a database in our previous chapter. You can select the database using either of the …

This chapter discusses about how to create a new database in your PostgreSQL. PostgreSQL provides two ways of creating a new database ?

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.

The PostgreSQL JOINS clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.

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 …

The PostgreSQL LIKE operator is used to match text values against a pattern using wildcards. If the search expression can be matched to the pattern expression, the LIKE operator will return …

In PostgreSQL, a transaction is a logical unit of work that uses SQL queries to combine one or more database operations. These operations shows the sequences like INSERT, UPDATE, …

In PostgreSQL, the WITH query provides a way to write auxiliary statements for use in a larger query. It helps in breaking down complicated and large queries into simpler forms, which are …