PostgreSQL Tutorial: TRIM Function
Summary: In this tutorial, you will learn how to use PostgreSQL TRIM() function to remove the longest string that contains spaces or a particular character from a string.
PostgreSQL Tutorial: UNIQUE Constraint
Summary: in this tutorial, you will learn about PostgreSQL UNIQUE constraint to make sure that values stored in a column or a group of columns are unique across rows in a table.
PostgreSQL Tutorial: UPDATE
Summary: in this tutorial, you will learn how to use the PostgreSQL UPDATE statement to update existing data in a table.
PostgreSQL Tutorial: UPDATE JOIN
Summary: in this tutorial, you will learn how to use the PostgreSQL UPDATE join syntax to update data in a table based on values in another table.
PostgreSQL Tutorial: Upsert Using INSERT ON CONFLICT statement
Summary: in this tutorial, you will learn how to use PostgreSQL upsert feature to insert or update data if the row that is being inserted already exists in the table.
PostgreSQL Tutorial: WHERE
Summary: in this tutorial, you will learn how to use PostgreSQL WHERE clause to filter rows returned by a SELECT statement.
PostgreSQL Java Tutorial: Call PostgreSQL Stored Function
Summary: in this tutorial, you will learn how to call PostgreSQL stored functions using JDBC.
PostgreSQL Java Tutorial: Delete Data From A PostgreSQL Table
Summary: in this tutorial, you will learn how to delete data from a table in the PostgreSQL database using JDBC.
PostgreSQL Java Tutorial: Insert Data Into a Table
Summary: in this tutorial, you will learn how to insert data into a table in the PostgreSQL database using JDBC API.
We will use the actor table in the sample database for the demonstration.
PostgreSQL Java Tutorial: PostgreSQL JDBC Transaction
Summary: in this tutorial, you will learn about the JDBC PostgreSQL transaction using JDBC transaction API.