The posts about PostgreSQL that were written for this blog can be found below. For quick reference only.
Category: PostgreSQL
VIEWS vs Materialized Views in SQL
Here are listed the key distinctions between Views and Materialized Views. This material has been gathered throughout time from a variety of sources and books.
Sub-Queries in SQL Server
A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
TRUNCATE TABLE in SQL
TRUNCATE TABLE is a Data Definition Language operation in SQL that marks the extent of a table for deallocation. This operation removes all data from
Naming Conventions in SQL
Why is a naming convention required in SQL? The short answer is READABILITY. A naming convention is a set of rules that you decide on
List tables in PostgreSQL
Unlike MySQL, Apache Hive, and Apache Impala, we can’t acquire a list of tables in PostgreSQL using the SHOW TABLES command. Use the below command
Big Data & SQL 