In this PostgreSQL tutorial, we will learn about “PostgreSQL cast int” using different data types or functions and casting or converting from int to another data type, such as boolean, float, timestamp, etc. PostgreSQL Cast Int When data is stored in a PostgreSQL database, we want to convert the data type of a value or column in the table into … Read more >>

In this PostgreSQL tutorial, I will show you how to use the Postgres Min Function with SELECT, GROUP BY, and HAVING clauses. You will also understand how to use the min() function with a subquery and multiple columns. Postgres Min Function PostgreSQL’s MIN() function finds the minimum value from the set of values. It is an aggregate function that … Read more >>

In this PostgreSQL tutorial, we will learn how to change column type in PostgreSQL from one data type to another. PostgreSQL change column data type Suppose you are an employee of XYZ company in the USA, and in front of you is a situation to change the data type of a column of a database. So, … Read more >>

To get the PostgreSQL length of a string, call length(): it counts characters, not bytes. Here’s the shortest version, with the byte count next to it: That returns 4 characters but 5 bytes, because é takes two bytes in UTF-8. In this tutorial, I’ll show you every PostgreSQL length function on one small customers table: … Read more >>

In this Postgresql tutorial, we will learn about “How to find primary column name in Postgresql“, primary columns are columns that uniquely identify each record in the table. And we will cover the following. How to find primary key column name in Postgresql In Postgresql, to get the primary key column name, we need to … Read more >>

In this PostgreSQL tutorial, we will learn about PostgreSQL CASE Multiple Columns with different examples such as using the simple and searched CASE. What are PostgreSQL CASE Multiple Columns? Similar to IF-THEN-ELSE statements in other programming languages, the CASE statement in PostgreSQL expresses a condition. It allows us to conditional login in SQL queries, which … Read more >>

In this PostgreSQL tutorial, we will discuss how to insert multiple rows in PostgreSQL in a single statement. PostgreSQL INSERT Multiple Rows You can insert more than one row at a time in a single statement in PostgreSQL by specifying comma-separated multiple-row values in value list form as VALUES in the INSERT INTO statement. Syntax To insert multiple rows in PostgreSQL, follow … Read more >>

If you need to change data that’s already in a table, the PostgreSQL UPDATE statement is the tool: UPDATE products SET price = 34.99 WHERE product_id = 3; changes only the rows the WHERE clause matches. People get stuck on what’s around it: a forgotten WHERE, a join that matches twice, or LIMIT, which UPDATE … Read more >>