Skip to main content
Home
  • My Account
    • Support Portal
    • Training Portal
    • Migration Portal
    • Partner Portal
    • Account Settings
    • Sign Out
  • Sign In
    • Sign In
  • Contact Us
  • Buy Now
  • Platform
    • EDB Postgres AI View the platform »
      • Core Database
      • Analytics
      • Agentic AI
      • Deploy Anywhere
    • FEATURED CAPABILITIES
      • Hybrid Manager
      • Agent Factory
      • Agentic Database
      • Warehouse Analytics
      • Distributed HA
      • Converged Analytics
      • Sovereign Data and AI Factory
      • Data and AI Governance
      • Agentic Migrations
      • OSS Library
    • BUILT ON OPEN SOURCE
      • PostgreSQL
      • WarehousePG
      • CloudNativePG
      • ClickHouse
  • Solutions
    • SERVICES
      • Sovereign Assurance
      • Technical Account Management
      • Managed Experiences
      • Customer Support
    • BLUEPRINTS
      • All Blueprints
      • BP 01: Real-Time ML Inference
      • BP 02: Agentic Analytics
      • BP 03: Sovereign Data Lakehouse
    • Industries
      • Banking
      • Government
      • Healthcare
      • InfoSec
      • Utilities
    • USE CASES
      • Sovereign AI
      • Legacy App Modernization
      • Hybrid DBaaS
      • Omni-Data Platform
      • Secure Open Source Software
      • Microservices with Kubernetes
      • More Use Cases »
  • Sovereignty
    • What Is Sovereignty? Data and AI sovereignty, explained
    • Sovereignty Research Our global study with 2,050 execs
    • Global Report Full methodology and statistical analsyis
    • The 4 Segments Summary report of success categories
    • Self-Assessment Tool Find out what category you belong in
    • Executive Infographic Visual summary of key statistics
    • Sovereignty in Banking Insights specific to the financial sector
    • Read the Study Developed in partnership with MIT
  • Partners
    • Partner Program
      • Partner Portal
      • Find a Partner
      • Become a Partner
    • Strategic Alliances
      • IBM
      • NVIDIA
      • Red Hat
      • Supermicro
  • Resources
    • Developer Support
      • Product Documentation EDB product documentation
      • Knowledge Base Searchable articles and updates
      • Support Support for PostgreSQL everywhere
      • Training Learn Postgres from EDB experts
      • EDB POSTGRES AI PLANS Key features and support terms
    • Legal & Technical
      • EDB Trust Center Knowledge base on our security posture
      • Platform Compatibility Supported versions and operating systems
      • Licensing Guide Defining EDB license entitlements
      • EDB EULA Simple access to the EDB EULA
      • EDB Purchase Program Simple access to products and services
    • DOWNLOADS
      • EDB Software Downloads EDB integrated portfolio of software
      • Open Source PostgreSQL PostgreSQL package and installers
    • LEARN & EXPLORE
      • Demos Tours of EDB Postgres AI capabilities
      • Benchmark Reports Studies of EDB Postgres AI performance
      • Blog Industry news and thought leadership
      • Events Find us at community and industry events
      • Webinars Upcoming and on-demand webinars
      • White Papers Postgres analysis from the experts
      • Podcast AI and Data Horizons: The Sovereign Future
      • Learning Library Introductory guides to Postgres topics
  • About
    • About EDB
    • Customers
    • Newsroom
    • Leadership
    • Careers
    • Contact Us

Header CTA

  • My Account
    • Support Portal
    • Training Portal
    • Migration Portal
    • Partner Portal
    • Account Settings
    • Sign Out
  • Sign In
    • Sign In
  • Contact Us
  • Buy Now

How to import data from Oracle into PostgreSQL

This article provides three methods for importing data from an Oracle database into PostgreSQL.
January 19, 2023

How to easily convert Oracle procedures to PostgreSQL

This article gives five examples of converting procedures from Oracle’s PL/SQL procedural language into PostgreSQL’s PL/pgSQL language.
January 19, 2023

How to convert Oracle Blobs to PostgreSQL

This article discusses binary large objects (Blobs) in Oracle and how to convert them into formats that PostgreSQL is able to use.
January 19, 2023

How to deploy PostgreSQL and EDB Postgres Platform on AWS using Terraform automation scripts 

With these deployment scripts, you can set up the PostgreSQL database of your choice (PG/EDB Postgres), and, in addition, the scripts will deploy and configure the tools that would take...
January 19, 2023

How to test unlogged tables for performance in PostgreSQL

This article looks at unlogged tables in PostgreSQL and reviews performance differences between unlogged tables and ordinary and temporary tables, as well as crash recovery.
January 19, 2023

How to Migrate Oracle's UNPIVOT to PostgreSQL

This article looks at the UNPIVOT function in Oracle and how to reproduce its result using PostgreSQL.
January 19, 2023

How does PostgreSQL master-replica failover work?

This article looks at the processes involved in master-replica failover in PostgreSQL and the options and commands that are available for configuring it.
January 19, 2023

How to implement faceted search with Django and PostgreSQL

This article discusses the advantages of faceted search and how to create a faceted search using Django and PostgreSQL.
January 19, 2023

How to make queries faster with multicolumn indexes

This article introduces multicolumn indexes and explains how they can by used to make large queries run faster.
January 19, 2023

PostgreSQL query tuning checklist

This article offers a checklist of tools available for improving PostgreSQL query performance.
January 19, 2023

Pagination

  • Previous page ‹‹
  • Page 16
  • Next page ››
Subscribe to Postgres Tutorials
edb postgres ai darkmode
Off
Off

Social Nav Footer

Footer Nav Main

  • Platform
    • EDB Postgres AI
    • Core Database
    • Analytics
    • Agentic AI
    • Deploy Anywhere
  • Solutions
    • Blueprints
    • Use Cases
    • Technical Account Management
    • Customer Support
    • Sovereign Assurance
    • Managed Experiences
  • Technical Resources
    • Product Documentation
    • EDB Software Downloads
    • Support Portal
    • Training
    • Trust Center
    • EDB Postgres AI Plans
  • Learn & Explore
    • Sovereignty
    • Blog
    • Customer Success Stories
    • Events
    • Webinars
    • White Papers
  • Company
    • About
    • Press & News
    • Careers
    • Strategic Alliances
    • Contact Us

Footer Copyright CTA

  • © 2026 EDB
  • Legal Notices
  • ESG
  • Privacy Policy
  • Marketing Preferences
  • Cookie Preferences