Build dashboards & reports in minutes

  • Features
  • Pricing
  • Blog
  • What is Ubiq
  • Free Trial

PostgreSQL

How to Prevent SQL Injection Attack

September 18, 2024September 18, 2024 Sreeram Sreenivasan MySQL, PostgreSQL, SQL, SQL Server
prevent sql injection

It is important to protect your website from SQL injection attack. Here are the steps to prevent SQL Injection (SQLi).

Continue reading


How to Check if PostgreSQL Array Contains Value

January 19, 2021July 29, 2024 Sreeram Sreenivasan 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, 2021July 2, 2024 Sreeram Sreenivasan 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, 2021July 4, 2024 Sreeram Sreenivasan 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, 2020July 8, 2024 Sreeram Sreenivasan 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, 2020July 12, 2024 Sreeram Sreenivasan 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, 2020July 17, 2024 Sreeram Sreenivasan 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, 2020July 25, 2024 Sreeram Sreenivasan 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, 2020July 29, 2024 Sreeram Sreenivasan 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, 2020August 1, 2024 Sreeram Sreenivasan 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


Posts navigation

Older posts

About Us



Ubiq is a business intelligence & reporting software. Build business dashboards, charts & reports in minutes. Get insights from data quickly. Try it for free!




Data Reporting
  • MySQL Reporting Tools
  • PostgreSQL Reporting Tools
  • Online Reporting Tools
  • Web Reporting Tools
  • Redshift BI Reporting
  • SQL Reporting Tools
Business Intelligence
  • BI Solution
  • BI Reporting Software
  • MySQL BI Reporting Tools
  • Self Service BI
  • SaaS BI
Data Visualization
  • Data Visualization Tools
  • Data Analysis Tools
  • Visual Analytics
  • MySQL Charts
  • MySQL Graph Generator
  • MySQL Report Builder
  • Online Report Generator
  • Redshift Data Visualization
Dashboards
  • Dashboard Builder
  • Dashboard Reporting Software
  • Dashboard Creator
  • KPI Dashboard Software
Quicklinks
  • Contact Us
  • Docs
  • Jobs
  • BI Blog
  • Database Blog
  • Tech Blog
Resources
  • Security
  • Privacy
  • T&C
  • Sitemap
dazzling Theme by Colorlib Powered by WordPress