ubiq

Build dashboards & reports in minutes

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

PostgreSQL

How to Check PostgreSQL version

November 25, 2020November 25, 2020 Ubiq PostgreSQL
how to check postgresql version

Sometimes you may need to find PostgreSQL version or get PostgreSQL version. Here is how to check PostgreSQL version for your database.

Continue reading


How To Change User to Superuser in PostgreSQL

November 24, 2020November 24, 2020 Ubiq PostgreSQL
how to change user to superuser in postgresql

Sometimes you may need to change user to superuser in PostgreSQL. Here is alter user to superuser in PostgreSQL.

Continue reading


How to Limit Access to Database in PostgreSQL

November 23, 2020November 23, 2020 Ubiq PostgreSQL
how to limit user access in postgresql

Sometimes you may need to restrict access to database in PostgreSQL. Here is how to limit access to database in PostgreSQL.

Continue reading


How To Alter Column From NULL to NOT NULL

November 23, 2020January 20, 2021 Ubiq MySQL, PostgreSQL, Redshift, SQL Server

Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.

Continue reading


How to Setup Remote Connection to PostgreSQL

November 20, 2020November 20, 2020 Ubiq PostgreSQL
remote connection in postgresql

You can easily enable remote access in PostgreSQL databases. Here is how to setup remote connection in PostgreSQL.

Continue reading


How To List Databases and Tables in PostgreSQL

November 18, 2020November 18, 2020 Ubiq PostgreSQL
list databases and tables in postgresql

Here are PostgreSQL commands to list all databases and list all tables in PostgreSQL.

Continue reading


How to Create Read Only User in PostgreSQL

November 16, 2020November 16, 2020 Ubiq PostgreSQL
create read only user postgresql

Read Only user has limited permissions and database access. Here is how to create read only user in PostgreSQL for reporting purposes.

Continue reading


How to Compare Two Schemas in PostgreSQL

November 9, 2020 Ubiq PostgreSQL
compare two schema in postgresql

Sometimes you may need to compare two schemas in PostgreSQL. Here’s how to compare schemas in PostgreSQL.

Continue reading


Top 5 Free Database Design Tools

November 4, 2020November 5, 2020 Ubiq MySQL, PostgreSQL, SQL Server
top database design tools

Database design tools allow you to design database schema, and simplify database administration. Here are the top 5 free database design tools for your business.

Continue reading


PostgreSQL Security Best Practices

October 30, 2020October 30, 2020 Ubiq PostgreSQL
postgresql security best practices

PostgreSQL Security Best Practices and Checklist will help you secure PostgreSQL database against security vulnerabilities.

Continue reading


Posts navigation

Older posts
Newer posts

About Us



Ubiq is a business intelligence & reporting tool for small & medium businesses. 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
  • 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
  • how to insert into array in postgresql
    How to Insert into Array in PostgreSQL Jan 5, 2021
dazzling Theme by Colorlib Powered by WordPress