Working with Hash partitions in PostgreSQL
With List and Range Partitions, you know exactly which data will go into which partition. But there are times when it is not obvious in which partition data should reside,…
Deep dive into NULL and Empty string in PostgreSQL
PostgreSQL database treats NULL as unknown. NULL is not same as empty or zero value. This is why you can not compare NULL with anything in PostgreSQL database. Comparison of…
NULL in Oracle vs. NULL in PostgreSQL
Database migration is conceptually though a simple task, but there are many uninvited challenges that database migration brings in. You can read our article Challenges during a typical data migration…
String concatenation using pipe “||” operator in PostgreSQL
PostgreSQL supports pipe "||" operator which is also called as string concatenation operator. PostgreSQL database also has CONCAT function to perform string concatenation. postgres=# SELECT 'This'||' is string'||' concat'||' example'…
PostgreSQL generate_series() function examples for random data generation
Generating massive amounts of data can be useful to test queries, indexes and tuning complex SQL queries on more realistic volumes, to get useful approximations of production like environment. This…
RAISE Statement in PostgreSQL to debug your query messages
RAISE statement in PostgreSQL is used to report messages and raise errors. PostgreSQL provides level option to specify with RAISE that specifies the severity of the statement. Possible levels with…
Validating database objects after migration from Oracle to PostreSQL
Managing databases to run at scale with high availability and reliability is difficult, time consuming and expensive. This is why, many companies are moving their databases to cloud to explore…
PG Function and some important attributes
Every PostgreSQL function has some special attributes which greatly determines its behavior. Every function in PostgreSQL has a volatility classification, with the possibility of being VOLATILE, STABLE, or IMMUTABLE. VOLATILE is the default if…