After a long time, when I tried to create a user and grant him all permissions on a certain database using- GRANT ALL PRIVILEGES ON
Category: PostgreSQL
UPSERT in SQL
The UPSERT statement combines the INSERT and UPDATE statements into one statement. If another row with the identical set of primary key values already exists
SQL-92 and SQL-89 Joins
SQL-92 and SQL-89 joins are supported by most RDBMSs, including Apache Impala. This article will explain how the syntax is written in both ways and
Apache Hive Aggregate Functions – Part-2
This is continuation part of “Apache Hive Aggregate Functions” Function: VARIANCE & VAR_POP Returns the population variance of the total number of records present in
Creating Linked Server for PostgreSQL in MSSQL
Creating a linked server in Microsoft SQL Server to connect PostgreSQL 1) Download the PostgreSQL Unicode (x64) driver to support ODBC. 2) Go to ODBC
Automation – PostgreSQL Restore Data
There are three methods to backing up PostgreSQL databases SQL dump File System Level backup Continuous archiving SQL Dump command used to take a full
Big Data & SQL 