Enroll in PostgreSQL Courses
Get Started
Use Code 'DBGRP30' for 30% OffCategory
-
Join 160 other subscribers
Top Posts & Pages
Archives
-
Recent Posts
- Why Ora2Pg Should Be Your First Stop for PostgreSQL Conversion March 31, 2026
- Oracle & SQL Server to PostgreSQL – Migration Tooling Gotchas No One Warns You About! March 27, 2026
- PostgreSQL Sequence Reset: START WITH vs RESTART WITH vs SETVAL Explained March 21, 2026
- PGConf India 2026: PostgreSQL Query Tuning: A Foundation Every Database Developer Should Build March 13, 2026
- Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bug January 30, 2026
- PostgreSQL Table Rename and Views – An OID Story January 5, 2026
- PostgreSQL Partition Pruning: The Role of Function Volatility November 4, 2025
- Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly September 28, 2025
- PostgreSQL Case-Insensitive Search: Handling LIKE with Nondeterministic Collations September 6, 2025
- PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease May 10, 2025
- Understanding Volatility in PL/pgSQL Functions: A Real-World Lesson November 10, 2024
- PL/pgSQL Secrets: How Conditional Expressions Are Parsed and Evaluated Under the Hood. November 2, 2024
-
Enhance your PostgreSQL skills! Master Database Development and Migration with my course. Click here to start!
Tag Archives: programming
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 1 – PL/pgSQL
PostgreSQL 17 Beta, released on May 23, 2024, introduces new features for database developers and migration engineers. One notable addition is the ability to declare array types directly based on underlying database objects, enhancing code readability and maintainability. These enhancements empower developers to leverage the full potential of PostgreSQL 17 in their projects. Continue reading
Posted in postgresql
Tagged 17, beta, conversion, database, new feature, plpgsql, postgres, postgresql, PostgreSQL 17, programming, SQL
10 Comments
Conversion Chronicles – Mapping Oracle Number Data types using AWS SCT and Ora2pg.
Mapping Oracle Number Data types is crucial during migration, and AWS Schema Conversion Tool (SCT) and Ora2pg play vital roles. SCT offers precise mapping with custom transformations and constraint-based data type mapping. Ora2pg defaults to bigint for unassigned precision or scale and provides comprehensive configuration options, including custom script integration for automation. Continue reading
Posted in Oracle to PG migration, postgresql
Tagged aws sct, bigint, conversion, data type, database, double precision, number, numeric, ora2pg, oracle, postgres, postgresql, precision, programming, scale, SQL
Leave a comment
PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.
Databases Cursors are one of the key components of development. We have been using them for traversing query results for processing based on business logic or functionality. In Code Conversion, Cursor code always needs to be ported either from PL\SQL … Continue reading
Posted in Oracle to PG migration, postgresql
Tagged conversion, cursor, database, for loop, found, oracle, plpgsql, PLSQL, postgresql, programming
2 Comments
PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables.
Whether during conversions or new development, it’s essential to avoid variable names that could create ambiguity within functions or procedures.In the blog, we will walk through how to resolve variables conflicts within functions or procedures. Continue reading
Posted in Oracle to PG migration, postgresql
Tagged ambiguity, conversion, database, development, PL/pgSQL, postgres, postgresql, programming, SQL, variable
4 Comments
Database and Migration Insights 
