Getting an OCI Database with PostgreSQL Configuration's Details

View the details of an OCI Database with PostgreSQL database system configuration, including its variables and extensions.

    1. On the Configurations list page, select the configuration that you want to work with. If you need help finding the list page or the configuration, see Listing OCI Database with PostgreSQL Configurations.
      The configuration's details page opens.
    2. Select System variables (Read only) to view the system variables associated with the configuration, or select User variables (Read/Write) to view the user variables.
  • Use the oci psql default-configuration get command and required parameters to get a default configuration:

    oci psql default-configuration get --configuration-id <configuration_ocid> [OPTIONS]

    To get your configuration's OCID, see Listing Configurations.

    Use the oci psql configuration get command and required parameters to get a custom configuration:

    oci psql configuration get --configuration-id <configuration_ocid> [OPTIONS]

    For a complete list of parameters and values for CLI commands, see the CLI Command Reference.

  • Run the GetDefaultConfiguration operation to get details about a default configuration. Run the GetConfiguration operation to get details about a custom configuration.