PostgreSQL: Use PSQL command line variable to make your SQL Queries Dynamic

In this post, I am sharing tips like how to use a psql session variable to make your queries more dynamic in PostgreSQL. As a DBA, we prepared lots of .sql files in our server for different purposes like check DB stats, get tables size, get object information. We are executing this scripts (.sql files) […]

June 19, 2017 PostgreSQL

June 18, 2017 5

SQL Puzzle: SQL Advance Query – Find first 100 Prime numbers in SQL Server

June 17, 2017

SQL Puzzle: SQL Advance Query – Draw a Triangle without using any Loop

June 16, 2017

SQL Puzzle: SQL Advance Query – Find the distinct combination from cross Columns

June 15, 2017

Greenplum: Script to find Role information with associated Resource Queue

June 14, 2017 2

SQL Puzzle: Advance SQL Query – Convert single cell of table into multiple Rows

June 13, 2017

PostgreSQL: Find a list of active Temp tables with Size and User information

June 12, 2017

SQL Server: How to keep a few records in Top result of ORDER BY

June 11, 2017 1

Linux: Importance of first line comment “#!/bin/sh” in a shell script

June 10, 2017

Linux: If your shell script is running, skip the next execution and exit it

Older posts Newer posts

About Me!