ubiq

Build dashboards & reports in minutes

  • Blog
  • What is Ubiq
  • Free Trial

PostgreSQL

How to Check if PostgreSQL Array Contains Value

January 19, 2021January 19, 2021 Ubiq PostgreSQL
check value in postgresql array

Sometimes you may need to check if value exists in array. Here is how to check if PostgreSQL array contains value.

Continue reading


How to Update Array in PostgreSQL

January 15, 2021January 15, 2021 Ubiq PostgreSQL
update array in postgresql

Sometimes you may need to update array in PostgreSQL with new data. In this article, we will look at how to change array in PostgreSQL, modify array in PostgreSQL, and merge arrays in PostgreSQL.

Continue reading


How to Insert into Array in PostgreSQL

January 5, 2021January 5, 2021 Ubiq PostgreSQL
how to insert into array in postgresql

PostgreSQL allows you to select into array, append to array and insert array of objects. Here is how to insert into array in PostgreSQL.

Continue reading


How to Create Array in PostgreSQL

December 21, 2020January 5, 2021 Ubiq PostgreSQL
create array in postgresql

PostgreSQL allows you to store array or create arrays with range. Here is how to create array in PostgreSQL.

Continue reading


How to Convert String Case in PostgreSQL

December 17, 2020December 17, 2020 Ubiq PostgreSQL
convert string case in postgresql

Sometimes you may need to convert lowercase to uppercase or uppercase to lowercase. Here is how to convert case of string in PostgreSQL

Continue reading


How to Concatenate Strings in PostgreSQL

December 15, 2020December 15, 2020 Ubiq PostgreSQL
how to concatenate string in postgresql

You can easily concatenate columns & strings in PostgreSQL. Here is how to concatenate strings in PostgreSQL.

Continue reading


How to Update Multiple Columns in PostgreSQL

December 8, 2020December 15, 2020 Ubiq PostgreSQL
update multiple columns in postgresql

Sometimes you may need to change values of multiple columns in PostgreSQL. Here is how to update multiple columns in PostgreSQL

Continue reading


How To Compare Arrays in PostgreSQL

December 3, 2020December 3, 2020 Ubiq PostgreSQL
compare arrays in postgresql

PostgreSQL allows you to compare arrays using operators. Here is how to compare arrays in PostgreSQL.

Continue reading


How To Change User Password in PostgreSQL

December 1, 2020December 1, 2020 Ubiq PostgreSQL
change user password in postgresql

Sometimes you may need to change user password in PostgreSQL. Here are the steps to change user password in PostgreSQL.

Continue reading


How To Create User With Superuser Privileges in PostgreSQL

November 30, 2020November 30, 2020 Ubiq PostgreSQL
how to create user with superuser privileges in postgresql

You need to create superuser for database administration. Here is how to create user with superuser privileges in PostgreSQL.

Continue reading


Posts navigation

Older posts

About Us



Ubiq is a business intelligence & reporting tool that makes it easy to get insights from data. Build business dashboards, charts & reports in minutes.Try it Today!




  • Popular
  • Recent
  • transpose rows columns dynamically
    How to Transpose Rows to Columns Dynamically in MySQL Feb 12, 2020
  • calculate percentage of column in mysql
    How to Calculate Percentage of Column in MySQL Jan 6, 2020
  • calculate total sales per month in mysql
    How to Calculate Total Sales Per Month in MySQL? Mar 25, 2020
  • How to create a read-only MySQL user? Nov 25, 2013
  • get last record in each group
    How To Get Last Record In Each Group In MySQL May 27, 2020
  • calculate moving average mysql
    How to Calculate Moving Average in MySQL Feb 17, 2020
  • import csv to mysql workbench
    How to Import CSV to MySQL Workbench Apr 30, 2020
  • check value in postgresql array
    How to Check if PostgreSQL Array Contains Value Jan 19, 2021
  • coalesce in mysql
    How to Use Coalesce in MySQL Jan 19, 2021
  • query json column in mysql
    How to Query JSON column in MySQL Jan 18, 2021
  • avoid inserting duplicate records in mysql
    How To Avoid Inserting Duplicate Records in MySQL Jan 18, 2021
  • update array in postgresql
    How to Update Array in PostgreSQL Jan 15, 2021
  • get multiple count in mysql
    How to Get Multiple Counts With Single Query in MySQL Jan 15, 2021
  • convert datetime to utc in mysql
    How to Convert datetime to UTC in MySQL Jan 14, 2021
dazzling Theme by Colorlib Powered by WordPress