corpus.blog
41554 blogs · [ { "id": "01a08768-6b70-7201-9924-35866ea6d580", "title": "Why Ora2Pg Should Be Your First Stop for PostgreSQL Conversion", "url": "https://databaserookies.wordpress.com/2026/03/31/why-ora2pg-should-be-your-first-stop-for-postgresql-conversion/", "published_at": "2026-03-31T08:16:22+00:00" }, { "id": "01a08768-6b70-7201-9924-35866f56cea6", "title": "Oracle & SQL Server to PostgreSQL – Migration Tooling Gotchas No One Warns You About!", "url": "https://databaserookies.wordpress.com/2026/03/27/oracle-sql-server-to-postgresql-migration-tooling-gotchas-no-one-warns-you-about/", "published_at": "2026-03-26T18:37:08+00:00" }, { "id": "01a08768-6b70-7201-9924-35866fdfb9fd", "title": "PostgreSQL Sequence Reset: START WITH vs RESTART WITH vs SETVAL Explained", "url": "https://databaserookies.wordpress.com/2026/03/21/postgresql-sequence-reset-start-with-vs-restart-with-vs-setval-explained/", "published_at": "2026-03-21T12:58:25+00:00" }, { "id": "01a08768-6b70-7201-9924-35867025a975", "title": "PGConf India 2026: PostgreSQL Query Tuning: A Foundation Every Database Developer Should Build", "url": "https://databaserookies.wordpress.com/2026/03/13/pgconf-india-2026-postgresql-query-tuning-a-foundation-every-database-developer-should-build/", "published_at": "2026-03-13T01:12:23+00:00" }, { "id": "01a08768-6b70-7201-9924-358671162bef", "title": "Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bug", "url": "https://databaserookies.wordpress.com/2026/01/30/same-sql-different-results-a-subtle-oracle-vs-postgresql-migration-bug/", "published_at": "2026-01-30T14:52:35+00:00" }, { "id": "01a08768-6b70-7201-9924-358671862397", "title": "PostgreSQL Table Rename and Views – An OID Story", "url": "https://databaserookies.wordpress.com/2026/01/05/postgresql-table-rename-and-views-an-oid-story/", "published_at": "2026-01-05T08:53:12+00:00" }, { "id": "01a08768-6b71-7178-8743-73e2fba21351", "title": "PostgreSQL Partition Pruning: The Role of Function Volatility", "url": "https://databaserookies.wordpress.com/2025/11/04/postgresql-partition-pruning-the-role-of-function-volatility/", "published_at": "2025-11-04T14:39:01+00:00" }, { "id": "01a08768-6b71-7178-8743-73e2fbafcfe4", "title": "Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly", "url": "https://databaserookies.wordpress.com/2025/09/28/postgres-18-copy-command/", "published_at": "2025-09-28T06:39:36+00:00" }, { "id": "01a08768-6b71-7178-8743-73e2fc88fbcb", "title": "PostgreSQL Case-Insensitive Search: Handling LIKE with Nondeterministic Collations", "url": "https://databaserookies.wordpress.com/2025/09/06/postgresql-case-insensitive-search-handling-like-with-nondeterministic-collations/", "published_at": "2025-09-06T08:43:49+00:00" }, { "id": "01a08768-6b71-7178-8743-73e2fcac42cf", "title": "PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease", "url": "https://databaserookies.wordpress.com/2025/05/10/postgresql-18-beta-preview-export-or-amend-statistics-with-ease/", "published_at": "2025-05-10T17:56:51+00:00" }, { "id": "01a0c506-2575-7070-bf39-8738091ea932", "title": "Understanding Volatility in PL/pgSQL Functions: A Real-World Lesson", "url": "https://databaserookies.wordpress.com/2024/11/10/understanding-volatility-in-plpgsql/", "published_at": "2024-11-10T13:44:13+00:00" }, { "id": "01a0c506-2575-7070-bf39-873809a97aa3", "title": "PL/pgSQL Secrets: How Conditional Expressions Are Parsed and Evaluated Under the Hood.", "url": "https://databaserookies.wordpress.com/2024/11/02/plpgsql-how-conditional-expressions-are-evaluated/", "published_at": "2024-11-02T09:35:50+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380a687433", "title": "How to Connect to PostgreSQL Database Through AWS SSM Using pgAdmin or DBeaver.", "url": "https://databaserookies.wordpress.com/2024/09/26/how-to-connect-to-postgresql-database-through-aws-ssm-using-pgadmin-or-dbeaver/", "published_at": "2024-09-26T06:31:45+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380b2baa72", "title": "Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance.", "url": "https://databaserookies.wordpress.com/2024/09/23/pg_maintain-postgres17/", "published_at": "2024-09-23T07:15:04+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380bca0089", "title": "Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 6: Login Event Trigger", "url": "https://databaserookies.wordpress.com/2024/08/31/postgres17-login-event-trigger/", "published_at": "2024-08-31T01:27:45+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380c25c798", "title": "Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 5 : Correlated IN Clause Transformation", "url": "https://databaserookies.wordpress.com/2024/08/27/postgresql17-correlated-in-clause-transformation/", "published_at": "2024-08-26T21:36:17+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380d14e716", "title": "Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 4: Enhanced Merge Command.", "url": "https://databaserookies.wordpress.com/2024/08/09/enhanced-merge-command/", "published_at": "2024-08-09T13:49:25+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380d93c893", "title": "Simplify PostgreSQL Execution Plan Analysis with pg_sqltxplain.", "url": "https://databaserookies.wordpress.com/2024/08/02/pg_sqltxplain/", "published_at": "2024-08-01T22:16:16+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380e19c22d", "title": "Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 3: The COPY Command Gets More User-Friendly", "url": "https://databaserookies.wordpress.com/2024/07/17/postgres-17-copy/", "published_at": "2024-07-17T14:12:28+00:00" }, { "id": "01a0c506-2575-7070-bf39-87380e5747a8", "title": "pgextensions.org: Your Guide to PostgreSQL Extensions Comparision on the Cloud", "url": "https://databaserookies.wordpress.com/2024/07/02/pgextensions-org-your-guide-to-postgresql-extensions-in-the-cloud/", "published_at": "2024-07-01T21:36:34+00:00" }, { "id": "01a0c517-8ea3-705d-9e3e-8cbfe2fb8246", "title": "Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 2 – Null Constraints and Performance.", "url": "https://databaserookies.wordpress.com/2024/06/11/exploring-postgresql-17-a-developers-guide-to-new-features-part-2-nulls-constraint-and-performance/", "published_at": "2024-06-11T12:41:58+00:00" }, { "id": "01a0c517-8ea3-705d-9e3e-8cbfe3f2c428", "title": "Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 1 – PL/pgSQL", "url": "https://databaserookies.wordpress.com/2024/06/08/exploring-postgresql-17-a-developers-guide-to-new-features-part-1-pl-pgsql/", "published_at": "2024-06-08T12:53:28+00:00" }, { "id": "01a0c517-8ea3-705d-9e3e-8cbfe4bd69ed", "title": "Code Conversion Chronicles – Trigger Order of processing in Oracle to PostgreSQL Migration.", "url": "https://databaserookies.wordpress.com/2024/05/27/code-conversion-chronicles-trigger-order-of-processing-in-oracle-to-postgresql-migration/", "published_at": "2024-05-27T17:02:53+00:00" }, { "id": "01a0c517-8ea3-705d-9e3e-8cbfe547cd6b", "title": "Optimizing Performance in PostgreSQL: Join Column and ANY Filters", "url": "https://databaserookies.wordpress.com/2024/05/23/optimizing-performance-in-postgresql-join-column-and-any-filters/", "published_at": "2024-05-23T07:54:27+00:00" }, { "id": "01a0c517-8ea3-705d-9e3e-8cbfe634cfb3", "title": "Conversion Chronicles – Invisible Indexes in Oracle to PostgreSQL Migration.", "url": "https://databaserookies.wordpress.com/2024/05/13/conversion-chronicles-invisible-indexes-in-oracle-to-postgresql-migration/", "published_at": "2024-05-13T15:22:04+00:00" }, { "id": "01a0c517-8ea3-705d-9e3e-8cbfe650e43f", "title": "Conversion Chronicles – Mapping Oracle Number Data types using AWS SCT and Ora2pg.", "url": "https://databaserookies.wordpress.com/2024/05/09/conversion-chronicles-mapping-oracle-number-data-types-using-aws-sct-and-ora2pg/", "published_at": "2024-05-08T21:31:29+00:00" }, { "id": "01a0c517-8ea3-705d-9e3e-8cbfe6c88251", "title": "Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration", "url": "https://databaserookies.wordpress.com/2024/05/03/conversion-gotchas-implicit-conversion-in-oracle-to-postgresql-migration/", "published_at": "2024-05-03T05:51:31+00:00" }, { "id": "01a0c517-8ea4-7165-bd76-e9af2b077601", "title": "PL\\pgSQL Conversion Gotchas : Functions with Out parameter and return type.", "url": "https://databaserookies.wordpress.com/2024/04/23/plpgsql-conversion-gotchas-functions-with-out-parameter-and-return-type/", "published_at": "2024-04-23T06:11:07+00:00" }, { "id": "01a0c517-8ea4-7165-bd76-e9af2b5c56f0", "title": "PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.", "url": "https://databaserookies.wordpress.com/2024/04/12/pl-pgsql-conversion-gotchas-cursors-and-last-fetch/", "published_at": "2024-04-12T05:18:54+00:00" }, { "id": "01a0c517-8ea4-7165-bd76-e9af2bb62c22", "title": "PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables.", "url": "https://databaserookies.wordpress.com/2024/04/10/pl-pgsql-conversion-gotchas-how-to-handle-conflicting-variables/", "published_at": "2024-04-10T05:24:15+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45f8960e0c", "title": "Why I Love psql – PostgreSQL Terminal.", "url": "https://databaserookies.wordpress.com/2024/03/05/why-i-love-psql-postgresql-terminal/", "published_at": "2024-03-05T07:00:40+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45f8d30f82", "title": "Uncovering and Exploring ROW Constructors in PostgreSQL.", "url": "https://databaserookies.wordpress.com/2024/02/27/uncovering-and-exploring-row-constructors-in-postgresql/", "published_at": "2024-02-27T13:55:13+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45f9966aeb", "title": "Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle.", "url": "https://databaserookies.wordpress.com/2023/12/16/key-postgresql-extensions-every-developer-must-know-when-migrating-from-oracle/", "published_at": "2023-12-16T12:00:56+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45fa7fef2e", "title": "PostgreSQL 16 Feature : Sub-Query Aliases and its usage in Code Conversion.", "url": "https://databaserookies.wordpress.com/2023/10/02/postgresql-16-feature-sub-query-aliases-and-its-usage-in-code-conversion/", "published_at": "2023-10-02T12:17:25+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45fb2a7ca0", "title": "Analytical Functions: Count of Distinct in Oracle vs. PostgreSQL", "url": "https://databaserookies.wordpress.com/2023/06/02/analytical-functions-count-of-distinct-in-oracle-vs-postgresql/", "published_at": "2023-06-02T08:33:51+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45fc0ec5fa", "title": "Subtle Art of Code Conversion in Oracle to PostgreSQL Migration.", "url": "https://databaserookies.wordpress.com/2023/05/13/subtle-art-of-code-conversion-in-oracle-to-postgresql-migration/", "published_at": "2023-05-13T16:01:57+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45fc759183", "title": "Maximizing PostgreSQL’s Charms: A Pattern for Indexes and Skewness When Migrating from Oracle", "url": "https://databaserookies.wordpress.com/2023/04/02/maximizing-postgresqls-charms-a-pattern-for-indexes-and-skewness-when-migrating-from-oracle/", "published_at": "2023-04-01T19:44:14+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45fd609930", "title": "Get the most out of PostgreSQL using psql with must known features.", "url": "https://databaserookies.wordpress.com/2023/02/14/get-the-most-out-of-postgresql-using-psql-with-must-known-features/", "published_at": "2023-02-14T13:43:50+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45fdd70455", "title": "The Differences Between the SUBSTR Functions in Oracle and PostgreSQL: What You Need to Know", "url": "https://databaserookies.wordpress.com/2023/01/09/substr-functionality-differences-between-oracle-and-postgresql-what-you-need-to-know/", "published_at": "2023-01-09T12:10:40+00:00" }, { "id": "01a0c522-8cdb-734d-b4e0-7e45fdf1675a", "title": "Postgres boolean data type casting: Unleashing the power of true and false.", "url": "https://databaserookies.wordpress.com/2023/01/08/unleasing-boolean-data-type-casting-in-postgresql/", "published_at": "2023-01-08T05:46:45+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7ea58aa9e", "title": "Navigating Aliases in Oracle to PostgreSQL Migrations", "url": "https://databaserookies.wordpress.com/2023/01/06/navigating-aliases-in-oracle-to-postgresql-migrations/", "published_at": "2023-01-06T08:39:38+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7eadd498c", "title": "PostgreSQL 15 – Interesting feature with View having security invoker option.", "url": "https://databaserookies.wordpress.com/2022/11/02/1779/", "published_at": "2022-11-02T07:21:27+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7eb8fe9ed", "title": "Assignment feature with PostgreSQL 14 on Nested Array type", "url": "https://databaserookies.wordpress.com/2022/07/19/assignment-feature-with-postgresql-14-on-nested-array-type/", "published_at": "2022-07-19T09:00:12+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7ec1379e6", "title": "Oracle internal view options with PostgreSQL Compatible.", "url": "https://databaserookies.wordpress.com/2022/01/08/oracle-internal-view-options-with-postgresql-compatible/", "published_at": "2022-01-08T11:54:12+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7ecb09395", "title": "Uncovering the Mystery of Comparing NULL Data in PostgreSQL", "url": "https://databaserookies.wordpress.com/2021/12/12/can-null-be-comparable-in-postgresql/", "published_at": "2021-12-11T20:46:52+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7ed90c86f", "title": "Interesting PSQL features from PostgreSQL releases you don’t wanna miss.", "url": "https://databaserookies.wordpress.com/2021/12/05/postgresql-13-and-14-psql-features-releases/", "published_at": "2021-12-05T13:04:39+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7ee04ece5", "title": "PostgreSQL 14 Lesser known Features – Uniquely track a query", "url": "https://databaserookies.wordpress.com/2021/11/27/postgresql-14-lesser-known-features-uniquely-track-a-query/", "published_at": "2021-11-27T15:08:56+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7ee11edf4", "title": "Feature or anomaly with Integer column and float values on Relational database.", "url": "https://databaserookies.wordpress.com/2021/09/19/feature-or-anomaly-with-integer-on-relational-database/", "published_at": "2021-09-18T21:23:38+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7ee53d0f9", "title": "Numeric types and implicit conversion in PostgreSQL", "url": "https://databaserookies.wordpress.com/2021/09/18/numeric-types-and-implicit-conversion-in-postgresql/", "published_at": "2021-09-18T17:56:29+00:00" }, { "id": "01a0c52e-07c6-7157-8bd4-d3d7eeeac381", "title": "Enable and Integrate External Editor with psql command line.", "url": "https://databaserookies.wordpress.com/2021/09/13/enable-external-editor-with-psql-command-line/", "published_at": "2021-09-13T06:44:58+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd396b2598e", "title": "Decode and NULL condition with Oracle to PostgreSQL Migration.", "url": "https://databaserookies.wordpress.com/2021/08/14/decode-and-null-condition-with-oracle-to-postgresql-migration/", "published_at": "2021-08-14T06:33:58+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd397ae20a8", "title": "How to Handle No Data Found with Scalar function in Oracle to PostgreSQL Migration.", "url": "https://databaserookies.wordpress.com/2021/05/08/scalar-functions-and-no-data-found-in-oracle-to-postgresql-migration/", "published_at": "2021-05-08T08:32:56+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd39853d4d2", "title": "How to Improve Password Management in Aurora/RDS PostgreSQL", "url": "https://databaserookies.wordpress.com/2020/05/16/password-management-within-database-with-aurora-rds-postgres/", "published_at": "2020-05-16T15:21:54+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd39921051a", "title": "DML Error Logging Implementation in PostgreSQL.", "url": "https://databaserookies.wordpress.com/2020/05/08/dml-error-logging-implementation-in-postgres-as-compatible-option-for-oracle-migrations/", "published_at": "2020-05-07T18:50:23+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd3995fff99", "title": "DDL within Transaction comparison in PostgreSQL and Oracle.", "url": "https://databaserookies.wordpress.com/2020/04/26/ddl-within-transaction-in-postgres-and-oracle/", "published_at": "2020-04-26T05:15:10+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd39a414719", "title": "Export Table to S3 in Amazon Aurora PostgreSQL on Migrating away from Oracle using UTL_FILE.", "url": "https://databaserookies.wordpress.com/2020/04/17/migrate-oracle-utl_file-to-export-file-in-aurora-postgres/", "published_at": "2020-04-17T03:33:08+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd39a4b3eca", "title": "Migration of Function with Out Params to Postgres from Oracle.", "url": "https://databaserookies.wordpress.com/2020/04/15/migration-of-function-with-out-params-to-postgres-from-oracle/", "published_at": "2020-04-15T18:29:41+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd39b474a3c", "title": "Order by and Limiting Rows in Postgres and Oracle.", "url": "https://databaserookies.wordpress.com/2020/04/12/order-by-and-limiting-rows-in-postgres-and-oracle/", "published_at": "2020-04-12T08:59:21+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd39bec26ff", "title": "Exploring the Subtle Differences Between Indexing, NULL Handling, and Constraints in Oracle and PostgreSQL.", "url": "https://databaserookies.wordpress.com/2020/04/12/indexes-with-null-and-anti-constraint-filter-in-postgres-and-oracle/", "published_at": "2020-04-11T18:33:58+00:00" }, { "id": "01a0c538-af57-7020-95a8-acd39c51f274", "title": "Load and Filter records using aws_s3.table_import_from_s3 from S3 to RDS for PostgreSQL", "url": "https://databaserookies.wordpress.com/2020/04/10/filtered-records-using-copy-command-in-postgres-and-aws-rds/", "published_at": "2020-04-10T13:19:28+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba6d72b9f7", "title": "With Clause Performance improvement with PostgreSQL 12.", "url": "https://databaserookies.wordpress.com/2020/04/10/with-clause-performance-improvement-with-postgres-12/", "published_at": "2020-04-10T03:21:21+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba6daaf48b", "title": "How to Connect to Oracle Database Through SSH Tunnel Using SQL Developer.", "url": "https://databaserookies.wordpress.com/2020/02/03/oracle-connection-through-ssh-tunnel-using-sql-developer/", "published_at": "2020-02-03T09:06:55+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba6e9f3590", "title": "Distribute Database Table based on Custom Size Bucket.", "url": "https://databaserookies.wordpress.com/2019/12/17/distribute-database-table-based-on-custom-size-bucket/", "published_at": "2019-12-17T03:52:11+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba6f11ad0f", "title": "Migrate Function in the WITH clause in Oracle to PostgreSQL.", "url": "https://databaserookies.wordpress.com/2019/11/24/migrate-function-in-the-with-clause-in-oracle-to-postgresql/", "published_at": "2019-11-24T04:29:20+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba6f4ead24", "title": "Split Rows of a Table into Evenly distributed partitions in Oracle.", "url": "https://databaserookies.wordpress.com/2019/11/18/split-rows-of-a-table-into-evenly-distributed-partitions-in-oracle/", "published_at": "2019-11-18T13:47:42+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba6faf13b8", "title": "Difference between SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY", "url": "https://databaserookies.wordpress.com/2019/11/16/difference-between-select_catalog_role-and-select-any-dictionary/", "published_at": "2019-11-16T01:46:11+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba70a096c7", "title": "How to clear screen in PostgreSQL or psql terminal for Mac and Windows", "url": "https://databaserookies.wordpress.com/2019/11/07/clear-screen-in-psql-for-mac-and-windows/", "published_at": "2019-11-07T07:29:00+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba716e1507", "title": "High Scale Number to Character conversion truncated in Oracle.", "url": "https://databaserookies.wordpress.com/2019/11/07/high-scale-number-to-character-conversion-truncated-in-oracle/", "published_at": "2019-11-07T03:42:36+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba7193511f", "title": "Migrate Multitable Insert from Oracle to PostgreSQL.", "url": "https://databaserookies.wordpress.com/2019/10/26/migrate-multitable-insert-from-oracle-to-postgresql/", "published_at": "2019-10-25T22:34:47+00:00" }, { "id": "01a0c542-1fd8-702f-8a06-4cba71bccdf3", "title": "Convert the KEEP Clause in Dense_Rank\\Rank Analytical from Oracle to PostgreSQL", "url": "https://databaserookies.wordpress.com/2019/10/19/conversion-of-keep-clause-in-analytical-function-from-oracle-to-postgresql/", "published_at": "2019-10-19T06:39:05+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef33a9e9c4", "title": "Streamline Your PostgreSQL Migration from Oracle with Automated Procedural Code Conversion Sanity Testing.", "url": "https://databaserookies.wordpress.com/2019/10/03/1265/", "published_at": "2019-10-02T19:12:54+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef342dd802", "title": "Implicit Conversion consideration while migration from Oracle to PostgreSQL.", "url": "https://databaserookies.wordpress.com/2019/10/02/implicit-conversion-consideration-while-migration-from-oracle-to-postgresql/", "published_at": "2019-10-02T03:42:08+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef34ff747c", "title": "Distinct clause within Analytical function in PostgreSQL.", "url": "https://databaserookies.wordpress.com/2019/09/21/distinct-within-analytical-function-in-postgresql/", "published_at": "2019-09-20T20:02:12+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef357f2a89", "title": "Stream DML Changes from AWS RDS to S3 using Database Migration Services.", "url": "https://databaserookies.wordpress.com/2019/09/16/streams-dml-changes-from-rds-postgresql-to-s3-using-database-migration-services/", "published_at": "2019-09-16T08:54:53+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef35c4cd47", "title": "Data Migration : Recreate Sequence in PostgreSQL from Oracle", "url": "https://databaserookies.wordpress.com/2019/09/15/data-migration-recreate-sequence-in-postgresql-from-oracle/", "published_at": "2019-09-15T18:10:18+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef360ada9c", "title": "Dynamic Inbound Security rules for RDS Instance in AWS", "url": "https://databaserookies.wordpress.com/2019/08/05/dynamic-inbound-security-rules-for-rds-instance-in-aws/", "published_at": "2019-08-05T09:59:46+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef363e100e", "title": "Load Fixed Length File’s into Amazon RDS PostgreSQL.", "url": "https://databaserookies.wordpress.com/2019/08/02/load-fixed-length-files-into-amazon-rds-postgresql/", "published_at": "2019-08-01T19:24:35+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef37048ab2", "title": "Data Dictionary – user_constraints/user_cons_columns is slow in Oracle 12cR1", "url": "https://databaserookies.wordpress.com/2019/03/07/data-dictionary-user_constraints-user_cons_columns-is-slow-in-oracle-12cr1/", "published_at": "2019-03-07T09:25:59+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef3772aa95", "title": "Exploration of SQLite", "url": "https://databaserookies.wordpress.com/2019/03/06/1132/", "published_at": "2019-03-06T13:22:31+00:00" }, { "id": "01a0c54b-07a0-7377-87e5-bdef38592ee9", "title": "Oracle 19c – Hint Reports with DBMS_XPLAN", "url": "https://databaserookies.wordpress.com/2019/01/18/oracle-19c-hint-reports-with-dbms_xplan/", "published_at": "2019-01-18T09:03:28+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cadb6d61", "title": "Generate Script for Foreign key’s in SQL Server.", "url": "https://databaserookies.wordpress.com/2019/01/11/generate-script-for-foreign-keys-in-sql-server/", "published_at": "2019-01-11T12:29:19+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cae44d5f", "title": "Adding Default Column to a table in Oracle and SQL Server.", "url": "https://databaserookies.wordpress.com/2018/09/21/adding-default-column-to-a-table-in-oracle-and-sql-server/", "published_at": "2018-09-21T11:21:36+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4caf2162b", "title": "Aliasing Table in Oracle and SQL Server and interesting difference.", "url": "https://databaserookies.wordpress.com/2018/09/18/table-alias-in-oracle-and-sql-server/", "published_at": "2018-09-18T13:22:55+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cb290735", "title": "CHAR Datatype and ConCat in Oracle and SQL Server.", "url": "https://databaserookies.wordpress.com/2018/04/03/char-datatype-and-concat-in-oracle-and-sql-server/", "published_at": "2018-04-03T09:27:26+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cbbca6e7", "title": "SQL SERVER# : Get last possible time for a DAY.", "url": "https://databaserookies.wordpress.com/2017/06/02/sql-server-get-last-possible-time-for-a-day/", "published_at": "2017-06-02T11:02:49+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cc1e2f1c", "title": "FIXED length character storage and NULL in SQL Server.", "url": "https://databaserookies.wordpress.com/2017/05/31/fixed-length-character-storage-and-null-in-sql-server/", "published_at": "2017-05-31T11:36:59+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cc2514e2", "title": "APPROX_COUNT_DISTINCT in Oracle 12c.", "url": "https://databaserookies.wordpress.com/2017/05/24/approx_count_distinct-in-oracle-12c/", "published_at": "2017-05-24T11:13:07+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cc6ade4a", "title": "Lateral Views in Oracle 12c.", "url": "https://databaserookies.wordpress.com/2017/05/12/lateral-views-in-oracle-12c/", "published_at": "2017-05-12T07:27:39+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cc700937", "title": "SQL Server : Value Constructor Insight.", "url": "https://databaserookies.wordpress.com/2017/04/13/sql-server-value-constructor-insight/", "published_at": "2017-04-13T09:32:06+00:00" }, { "id": "01a0c553-5050-7010-a771-31f4cca7480c", "title": "SQL Server : ExecuteNonQuery shows incorrect rows affected.", "url": "https://databaserookies.wordpress.com/2017/04/06/sql-server-executenonquery-shows-incorrect-rows-affected/", "published_at": "2017-04-06T15:21:44+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce48d46767", "title": "SQL Server : Get Numeric part from a varchar/string.", "url": "https://databaserookies.wordpress.com/2017/04/06/sql-server-get-numeric-part-from-a-varcharstring/", "published_at": "2017-04-05T19:15:50+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce49005729", "title": "Date Generator in SQL Server using Recursive With Clause.", "url": "https://databaserookies.wordpress.com/2017/04/05/date-generator-in-sql-server-using-recursive-with-clause/", "published_at": "2017-04-05T13:14:49+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce49db1970", "title": "#SQLSERVERLearning : Order By Learning.", "url": "https://databaserookies.wordpress.com/2017/03/03/sqlserverlearning-order-by-learning/", "published_at": "2017-03-03T11:39:37+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce4a326f7c", "title": "How to Pad Strings in SQL Server-LPAD/RPAD", "url": "https://databaserookies.wordpress.com/2017/01/06/sqlserverlearning-string-padding-in-sql-server-lpadrpad/", "published_at": "2017-01-06T14:06:38+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce4a473114", "title": "#SQLSERVERLearning : Export Table data as Insert statement in SQL Server.", "url": "https://databaserookies.wordpress.com/2017/01/05/sqlserverlearning-export-table-data-as-insert-statement-in-sql-server/", "published_at": "2017-01-05T10:53:17+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce4ad4ee39", "title": "#SQLSERVERLearning : Column Data Type Conversion in Oracle and SQL Server.", "url": "https://databaserookies.wordpress.com/2017/01/04/sqlserverlearning-column-data-type-conversion-in-oracle-and-sql-server/", "published_at": "2017-01-04T06:42:13+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce4baa1560", "title": "Interesting New WITH Clause Feature in Oracle 12c.", "url": "https://databaserookies.wordpress.com/2016/12/23/interesting-new-with-clause-feature-in-oracle-12c/", "published_at": "2016-12-23T14:31:21+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce4c91011e", "title": "MIN , MAX and INDEX Access in Oracle.", "url": "https://databaserookies.wordpress.com/2016/12/20/min-max-and-index-access-in-oracle/", "published_at": "2016-12-19T19:09:07+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce4ccaf28b", "title": "#SQLSERVERLearning : String Concatenation for NULL and Empty String in Oracle and SQL Server", "url": "https://databaserookies.wordpress.com/2016/12/17/string-concatenation-for-null-and-empty-string-in-oracle-and-sqlserverlearning/", "published_at": "2016-12-17T12:38:33+00:00" }, { "id": "01a0c55b-c1c7-72d3-be35-05ce4d296669", "title": "#SQLSERVERLearning : CASE Statement Insight", "url": "https://databaserookies.wordpress.com/2016/12/16/sqlserverlearning-case-statement-insight/", "published_at": "2016-12-16T13:03:23+00:00" } ] posts Claim your blog
Back to databaserookies.wordpress.com
Blog · corpus.blog/blogs/databaserookies.wordpress.com/posts

databaserookies.wordpress.com

databaserookies.wordpress.com

2026

Why Ora2Pg Should Be Your First Stop for PostgreSQL Conversionoriginal ↗
31 Mar 2026
Oracle & SQL Server to PostgreSQL – Migration Tooling Gotchas No One Warns You About!original ↗
26 Mar 2026
PostgreSQL Sequence Reset: START WITH vs RESTART WITH vs SETVAL Explainedoriginal ↗
21 Mar 2026
PGConf India 2026: PostgreSQL Query Tuning: A Foundation Every Database Developer Should Buildoriginal ↗
13 Mar 2026
Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bugoriginal ↗
30 Jan 2026
PostgreSQL Table Rename and Views – An OID Storyoriginal ↗
5 Jan 2026

2025

PostgreSQL Partition Pruning: The Role of Function Volatilityoriginal ↗
4 Nov 2025
Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendlyoriginal ↗
28 Sept 2025
PostgreSQL Case-Insensitive Search: Handling LIKE with Nondeterministic Collationsoriginal ↗
6 Sept 2025
PostgreSQL 18 Beta Preview – Export or Amend Statistics with Easeoriginal ↗
10 May 2025

2024

Understanding Volatility in PL/pgSQL Functions: A Real-World Lessonoriginal ↗
10 Nov 2024
PL/pgSQL Secrets: How Conditional Expressions Are Parsed and Evaluated Under the Hood.original ↗
2 Nov 2024
How to Connect to PostgreSQL Database Through AWS SSM Using pgAdmin or DBeaver.original ↗
26 Sept 2024
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance.original ↗
23 Sept 2024
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 6: Login Event Triggeroriginal ↗
31 Aug 2024
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 5 : Correlated IN Clause Transformationoriginal ↗
26 Aug 2024
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 4: Enhanced Merge Command.original ↗
9 Aug 2024
Simplify PostgreSQL Execution Plan Analysis with pg_sqltxplain.original ↗
1 Aug 2024
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 3: The COPY Command Gets More User-Friendlyoriginal ↗
17 Jul 2024
pgextensions.org: Your Guide to PostgreSQL Extensions Comparision on the Cloudoriginal ↗
1 Jul 2024
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 2 – Null Constraints and Performance.original ↗
11 Jun 2024
Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 1 – PL/pgSQLoriginal ↗
8 Jun 2024
Code Conversion Chronicles – Trigger Order of processing in Oracle to PostgreSQL Migration.original ↗
27 May 2024
Optimizing Performance in PostgreSQL: Join Column and ANY Filtersoriginal ↗
23 May 2024
Conversion Chronicles – Invisible Indexes in Oracle to PostgreSQL Migration.original ↗
13 May 2024
Conversion Chronicles – Mapping Oracle Number Data types using AWS SCT and Ora2pg.original ↗
8 May 2024
Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migrationoriginal ↗
3 May 2024
PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type.original ↗
23 Apr 2024
PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.original ↗
12 Apr 2024
PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables.original ↗
10 Apr 2024
Why I Love psql – PostgreSQL Terminal.original ↗
5 Mar 2024
Uncovering and Exploring ROW Constructors in PostgreSQL.original ↗
27 Feb 2024

2023

Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle.original ↗
16 Dec 2023
PostgreSQL 16 Feature : Sub-Query Aliases and its usage in Code Conversion.original ↗
2 Oct 2023
Analytical Functions: Count of Distinct in Oracle vs. PostgreSQLoriginal ↗
2 Jun 2023
Subtle Art of Code Conversion in Oracle to PostgreSQL Migration.original ↗
13 May 2023
Maximizing PostgreSQL’s Charms: A Pattern for Indexes and Skewness When Migrating from Oracleoriginal ↗
1 Apr 2023
Get the most out of PostgreSQL using psql with must known features.original ↗
14 Feb 2023
The Differences Between the SUBSTR Functions in Oracle and PostgreSQL: What You Need to Knoworiginal ↗
9 Jan 2023
Postgres boolean data type casting: Unleashing the power of true and false.original ↗
8 Jan 2023
Navigating Aliases in Oracle to PostgreSQL Migrationsoriginal ↗
6 Jan 2023

2022

PostgreSQL 15 – Interesting feature with View having security invoker option.original ↗
2 Nov 2022
Assignment feature with PostgreSQL 14 on Nested Array typeoriginal ↗
19 Jul 2022
Oracle internal view options with PostgreSQL Compatible.original ↗
8 Jan 2022

2021

Uncovering the Mystery of Comparing NULL Data in PostgreSQLoriginal ↗
11 Dec 2021
Interesting PSQL features from PostgreSQL releases you don’t wanna miss.original ↗
5 Dec 2021
PostgreSQL 14 Lesser known Features – Uniquely track a queryoriginal ↗
27 Nov 2021
Feature or anomaly with Integer column and float values on Relational database.original ↗
18 Sept 2021
Numeric types and implicit conversion in PostgreSQLoriginal ↗
18 Sept 2021
Enable and Integrate External Editor with psql command line.original ↗
13 Sept 2021
Decode and NULL condition with Oracle to PostgreSQL Migration.original ↗
14 Aug 2021
How to Handle No Data Found with Scalar function in Oracle to PostgreSQL Migration.original ↗
8 May 2021

2020

How to Improve Password Management in Aurora/RDS PostgreSQLoriginal ↗
16 May 2020
DML Error Logging Implementation in PostgreSQL.original ↗
7 May 2020
DDL within Transaction comparison in PostgreSQL and Oracle.original ↗
26 Apr 2020
Export Table to S3 in Amazon Aurora PostgreSQL on Migrating away from Oracle using UTL_FILE.original ↗
17 Apr 2020
Migration of Function with Out Params to Postgres from Oracle.original ↗
15 Apr 2020
Order by and Limiting Rows in Postgres and Oracle.original ↗
12 Apr 2020
Exploring the Subtle Differences Between Indexing, NULL Handling, and Constraints in Oracle and PostgreSQL.original ↗
11 Apr 2020
Load and Filter records using aws_s3.table_import_from_s3 from S3 to RDS for PostgreSQLoriginal ↗
10 Apr 2020
With Clause Performance improvement with PostgreSQL 12.original ↗
10 Apr 2020
How to Connect to Oracle Database Through SSH Tunnel Using SQL Developer.original ↗
3 Feb 2020

2019

Distribute Database Table based on Custom Size Bucket.original ↗
17 Dec 2019
Migrate Function in the WITH clause in Oracle to PostgreSQL.original ↗
24 Nov 2019
Split Rows of a Table into Evenly distributed partitions in Oracle.original ↗
18 Nov 2019
Difference between SELECT_CATALOG_ROLE and SELECT ANY DICTIONARYoriginal ↗
16 Nov 2019
How to clear screen in PostgreSQL or psql terminal for Mac and Windowsoriginal ↗
7 Nov 2019
High Scale Number to Character conversion truncated in Oracle.original ↗
7 Nov 2019
Migrate Multitable Insert from Oracle to PostgreSQL.original ↗
25 Oct 2019
Convert the KEEP Clause in Dense_Rank\Rank Analytical from Oracle to PostgreSQLoriginal ↗
19 Oct 2019
Streamline Your PostgreSQL Migration from Oracle with Automated Procedural Code Conversion Sanity Testing.original ↗
2 Oct 2019
Implicit Conversion consideration while migration from Oracle to PostgreSQL.original ↗
2 Oct 2019
Distinct clause within Analytical function in PostgreSQL.original ↗
20 Sept 2019
Stream DML Changes from AWS RDS to S3 using Database Migration Services.original ↗
16 Sept 2019
Data Migration : Recreate Sequence in PostgreSQL from Oracleoriginal ↗
15 Sept 2019
Dynamic Inbound Security rules for RDS Instance in AWSoriginal ↗
5 Aug 2019
Load Fixed Length File’s into Amazon RDS PostgreSQL.original ↗
1 Aug 2019
Data Dictionary – user_constraints/user_cons_columns is slow in Oracle 12cR1original ↗
7 Mar 2019
Exploration of SQLiteoriginal ↗
6 Mar 2019
Oracle 19c – Hint Reports with DBMS_XPLANoriginal ↗
18 Jan 2019
Generate Script for Foreign key’s in SQL Server.original ↗
11 Jan 2019

2018

Adding Default Column to a table in Oracle and SQL Server.original ↗
21 Sept 2018
Aliasing Table in Oracle and SQL Server and interesting difference.original ↗
18 Sept 2018
CHAR Datatype and ConCat in Oracle and SQL Server.original ↗
3 Apr 2018

2017

SQL SERVER# : Get last possible time for a DAY.original ↗
2 Jun 2017
FIXED length character storage and NULL in SQL Server.original ↗
31 May 2017
APPROX_COUNT_DISTINCT in Oracle 12c.original ↗
24 May 2017
Lateral Views in Oracle 12c.original ↗
12 May 2017
SQL Server : Value Constructor Insight.original ↗
13 Apr 2017
SQL Server : ExecuteNonQuery shows incorrect rows affected.original ↗
6 Apr 2017
SQL Server : Get Numeric part from a varchar/string.original ↗
5 Apr 2017
Date Generator in SQL Server using Recursive With Clause.original ↗
5 Apr 2017
#SQLSERVERLearning : Order By Learning.original ↗
3 Mar 2017
How to Pad Strings in SQL Server-LPAD/RPADoriginal ↗
6 Jan 2017
#SQLSERVERLearning : Export Table data as Insert statement in SQL Server.original ↗
5 Jan 2017
#SQLSERVERLearning : Column Data Type Conversion in Oracle and SQL Server.original ↗
4 Jan 2017

2016

Interesting New WITH Clause Feature in Oracle 12c.original ↗
23 Dec 2016
MIN , MAX and INDEX Access in Oracle.original ↗
19 Dec 2016
#SQLSERVERLearning : String Concatenation for NULL and Empty String in Oracle and SQL Serveroriginal ↗
17 Dec 2016
#SQLSERVERLearning : CASE Statement Insightoriginal ↗
16 Dec 2016
Next