XML Developer
Oxygen XML Developer 20.0 User Guide
  • Getting Started
  • Editing Specific Document Types
  • Working with XPath Expressions
  • XSLT/XQuery Debugging
  • Tools
Index
  1. Home
  2. Databases and SharePoint

    Connecting to supported databases and integrating Oxygen XML Developer with SharePoint

  3. Working with Databases
  4. Database Connection Support
  5. PostgreSQL Database Connections
  6. Configuring a PostgreSQL Database Connection
  • Introduction

    Welcome to the User Manual of Oxygen XML Developer 20.0

  • Getting Started

    Information and resources to help you get started using Oxygen XML Developer as quickly as possible

  • Installation

    The requirements and installation instructions for each platform

  • Configuration

    Description of all of the options that allow you to configure Oxygen XML Developer

  • Perspectives

    The Editor, XSLT Debugger, XQuery Debugger, and Database perspectives

  • Editing Modes

    The Text, Grid, , and Schema Design editing modes

  • Working with Documents

    General information about working with any type of document in Oxygen

  • Editing Specific Document Types

    Details about the specific types of supported documents and their unique editing features

  • Built-in XML Frameworks

    The built-in frameworks that are supported in Oxygen XML Developer

  • Publishing

    Details about transformation scenarios and customizing various types of output

  • Working with XPath Expressions

    Information about using XPath Expressions in Oxygen XML Developer

  • Working with Archives

    Describes how to use the Archive Browser to work with various type of archives

  • Databases and SharePoint

    Connecting to supported databases and integrating Oxygen XML Developer with SharePoint

    • Working with Databases
      • Data Source Explorer View
      • Table Explorer View
      • Database Connection Support
        • IBM DB2 Database Connections
        • Microsoft SQL Server Database Connections
        • Oracle Database Connections
        • PostgreSQL Database Connections
          • Configuring a PostgreSQL Database Connection
            • How to Configure PostgreSQL 8.3 Data Source Drivers
            • How to Configure a PostgreSQL 8.3 Connection
          • PostgreSQL Contextual Menu Actions
        • Berkeley DB XML Database Connections
        • eXist Database Connections
        • MarkLogic Database Connections
        • Documentum xDB (X-Hive/DB) 10 Database Connections [Deprecated]
        • MySQL Database Connections
        • Generic JDBC Database Connections
        • JDBC-ODBC Database Connections
        • BaseX Database Connections
      • WebDAV Connections
      • SQL Execution Support
      • XQuery and Databases
    • Integration with Microsoft SharePoint
  • Importing Data

    How to import data from various external sources into XML documents

  • XSLT/XQuery Debugging

    The debugging interface that detects problems with XSLT and XQuery transformations

  • Using the Oxygen XML SDK

    Information about extending Oxygen XML Developer using the SDK

  • Add-ons

    Information about extending Oxygen XML Developer with default add-ons

  • Tools

    Specifics about the various tools that are included in Oxygen XML Developer

  • Common Problems

    A compilation of common problems and their solutions

  • Glossary
  • Copyright

    Legal information

Configuring a PostgreSQL Database Connection

To configure the support for a PostgreSQL database, follow this procedure:
  1. Go to http://jdbc.postgresql.org/download.html and download the PostgreSQL 8.3 JDBC3 driver.
  2. Configure PostgreSQL Data Source drivers.
  3. Configure a PostgreSQL Connection.
  4. To view your connection, go to the Data Source Explorer view (if the view is not displayed, it can be opened by selecting it from the Window > Show View menu) or switch to the Database perspective.
  1. How to Configure PostgreSQL 8.3 Data Source Drivers
  2. How to Configure a PostgreSQL 8.3 Connection