Skip to main content
Home
  • My Account
    • Dashboard
    • Rai Copilot
    • Support Portal
    • Training Portal
    • Migration Portal
    • Partner Portal
    • Account Settings
    • Sign Out
  • Sign In
    • EDB Login
    • EDB Postgres AI Login
  • Contact Us
  • EDB Postgres AI
    • PLATFORM
      • EDB POSTGRES AI
        • Database Always-on sovereign Postgres database
        • Hybrid Management Hybrid control and unified observability
        • AI Factory Low-code/no-code GenAI innovation
        • Analytics Accelerator Rapid insights from your operational data
        • Sovereign Assurance Subscription to optimize EDB Postgres AI
    • HOW TO DEPLOY
      • Hybrid Software Deploy in your environment of choice
      • Sovereign Data and AI Factory Turnkey system for AI-ready Postgres
      • Managed Platform Your platform, delivered and optimized
    • USE CASES
      • Sovereign AI
      • Legacy App Modernization
      • Hybrid DBaaS
      • Omni-Data Platform
      • Secure Open Source Software
      • Microservices with Kubernetes
      • MORE USE CASES
    • SERVICES & SUPPORT
      • Customer Support Increase your Postgres productivity and decrease your risk
      • Professional Services Expert services and support
      • Remote DBA Expert proactive support for your deployments
      • Technical Account Management Proactive guidance and partnership
  • Resources
    • TECHNICAL RESOURCES
      • Product Documentation EDB product documentation
      • Platform Compatibility Supported versions and operating systems
      • Knowledge Base Searchable articles and updates
      • Training Learn Postgres from EDB experts
      • Support Support for PostgreSQL everywhere
      • EDB Trust Center Knowledge base on our security posture
      • EDB Purchase Program Simple access to products and services
      • Licensing Guide Defining EDB license entitlements
      • EDB EULA Simple access to the EDB products and services EULA
      • EDB Postgres AI Plans Key features and support terms
    • DOWNLOADS
      • EDB Software Downloads EDB integrated portfolio of software
      • Open Source PostgreSQL Open source PostgreSQL package and installers
    • LEARN & EXPLORE
      • Blog Industry news and thought leadership
      • Customer Success Stories Achieving more with Postgres
      • Benchmark Reports Studies of EDB Postgres AI performance
      • Events Local events near you
      • Webinars Upcoming and on-demand webinars
      • Podcast AI and Data Horizons: The Sovereign Future
      • White Papers PostgreSQL research and analysis
      • Learning Library Introductory guides to Postgres topics

    DATA & AI SOVEREIGNTY

    DATA & AI SOVEREIGNTY
    WHAT IS SOVEREIGN AI?
    sovereign data teaser
    Learn why and how to build your AI on your terms with a data platform you control.
    Read More
  • Company
    • EDB
      • About EDB
      • Leadership
      • Press & News
      • Careers
      • Contact Us
    • STRATEGIC ALLIANCES
      • Amazon Web Services
      • Google Cloud Platform
      • Microsoft Azure
      • NVIDIA
      • Red Hat OpenShift
      • Supermicro
    • PARTNERS
      • Partner Portal
      • Become a Partner
      • Find a Partner
      • EDB Partners
      • Why Partner With EDB
      • EDB Partner Academy

    DATA & AI SOVEREIGNTY

    DATA & AI SOVEREIGNTY
    WHAT IS SOVEREIGN AI?
    sovereign data teaser
    Learn why and how to build your AI on your terms with a data platform you control.
    Read More

Header CTA

  • My Account
    • Dashboard
    • Rai Copilot
    • Support Portal
    • Training Portal
    • Migration Portal
    • Partner Portal
    • Account Settings
    • Sign Out
  • Sign In
    • EDB Login
    • EDB Postgres AI Login
  • Contact Us

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
    • Database
    • Hybrid Management
    • AI Factory
    • Analytics Accelerator
    • Sovereign Assurance
  • Use Cases
    • Sovereign AI
    • Legacy App Modernization
    • Hybrid DBaaS
    • Omni-data Platform
    • Secure Open Source Software
    • More Use Cases
  • Technical Resources
    • Product Documentation
    • EDB Software Downloads
    • Support Portal
    • Training
    • Trust Center
    • EDB Postgres AI Plans
    • EDB Purchase Program
  • Learn & Explore
    • Blog
    • Customer Success Stories
    • Events
    • Webinars
    • White Papers
    • Learning Library
  • Company
    • About
    • Leadership
    • Press & News
    • Careers
    • Partners
    • Contact Us

Footer Copyright CTA

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