PSQL Functions
Package: DBMS_CLOUD_OCI_PSQL_POSTGRESQL
CHANGE_BACKUP_COMPARTMENT Function
Moves a backup from one compartment to another. When provided, If-Match is checked against ETag values of the resource.
Syntax
FUNCTION change_backup_compartment (
backup_id varchar2,
change_backup_compartment_details dbms_cloud_oci_psql_change_backup_compartment_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_change_backup_compartment_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the backup. |
|
(required) The information to be updated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
CHANGE_CONFIGURATION_COMPARTMENT Function
Moves a configuration from one compartment to another. When provided, If-Match is checked against ETag values of the resource.
Syntax
FUNCTION change_configuration_compartment (
configuration_id varchar2,
change_configuration_compartment_details dbms_cloud_oci_psql_change_configuration_compartment_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_change_configuration_compartment_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the configuration. |
|
(required) The information to be updated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
CHANGE_DB_SYSTEM_COMPARTMENT Function
Moves a database system from one compartment to another. When provided, If-Match is checked against ETag values of the resource.
Syntax
FUNCTION change_db_system_compartment (
db_system_id varchar2,
change_db_system_compartment_details dbms_cloud_oci_psql_change_db_system_compartment_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_change_db_system_compartment_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) The information to be updated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
CREATE_BACKUP Function
Creates a new backup.
Syntax
FUNCTION create_backup (
create_backup_details dbms_cloud_oci_psql_create_backup_details_t,
opc_retry_token varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_create_backup_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) Details for the new backup. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
CREATE_CONFIGURATION Function
Creates a new configuration.
Syntax
FUNCTION create_configuration (
create_configuration_details dbms_cloud_oci_psql_create_configuration_details_t,
opc_retry_token varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_create_configuration_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) Details for the new configuration. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
CREATE_DB_SYSTEM Function
Creates a new database system.
Syntax
FUNCTION create_db_system (
create_db_system_details dbms_cloud_oci_psql_create_db_system_details_t,
opc_retry_token varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_create_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) Details for the new database system. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
DELETE_BACKUP Function
Deletes a backup by identifier.
Syntax
FUNCTION delete_backup (
backup_id varchar2,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_delete_backup_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the backup. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
DELETE_CONFIGURATION Function
Deletes a configuration by identifier.
Syntax
FUNCTION delete_configuration (
configuration_id varchar2,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_delete_configuration_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the configuration. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
DELETE_DB_SYSTEM Function
Deletes a database system by identifier.
Syntax
FUNCTION delete_db_system (
db_system_id varchar2,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_delete_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
FAILOVER_DB_SYSTEM Function
Runs a failover operation. Optionally, specify the desired AD for regions with three ADs.
Syntax
FUNCTION failover_db_system (
db_system_id varchar2,
failover_db_system_details dbms_cloud_oci_psql_failover_db_system_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_failover_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) The information to be updated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
GET_BACKUP Function
Gets a backup by identifier.
Syntax
FUNCTION get_backup (
backup_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_get_backup_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the backup. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
GET_CONFIGURATION Function
Gets a configuration by identifier.
Syntax
FUNCTION get_configuration (
configuration_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_get_configuration_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the configuration. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
GET_CONNECTION_DETAILS Function
Gets the database system connection details.
Syntax
FUNCTION get_connection_details (
db_system_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_get_connection_details_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
GET_DB_SYSTEM Function
Gets a database system by identifier.
Syntax
FUNCTION get_db_system (
db_system_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
excluded_fields dbms_cloud_oci_psql_varchar2_tbl DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_get_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(optional) The client request ID for tracing. |
|
(optional) A filter to exclude database configuration when this query parameter is set to OverrideDbConfig. Allowed values are: 'dbConfigurationParams' |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
GET_DEFAULT_CONFIGURATION Function
Gets a default configuration by identifier.
Syntax
FUNCTION get_default_configuration (
default_configuration_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_get_default_configuration_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the configuration. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
GET_PRIMARY_DB_INSTANCE Function
Gets the primary database instance node details.
Syntax
FUNCTION get_primary_db_instance (
db_system_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_get_primary_db_instance_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
GET_WORK_REQUEST Function
Gets details of the work request with the given ID.
Syntax
FUNCTION get_work_request (
work_request_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_get_work_request_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) The ID of the asynchronous request. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_BACKUPS Function
Returns a list of backups.
Syntax
FUNCTION list_backups (
compartment_id varchar2 DEFAULT NULL,
time_started timestamp with time zone DEFAULT NULL,
time_ended timestamp with time zone DEFAULT NULL,
lifecycle_state varchar2 DEFAULT NULL,
display_name varchar2 DEFAULT NULL,
backup_id varchar2 DEFAULT NULL,
id varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
page varchar2 DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_backups_response_t;
Parameters
Parameter | Description |
---|---|
|
(optional) The ID of the compartment in which to list resources. |
|
(optional) The start date for getting backups. An RFC 3339 formatted datetime string. |
|
(optional) The end date for getting backups. An RFC 3339 formatted datetime string. |
|
(optional) A filter to return only resources if their `lifecycleState` matches the given `lifecycleState`. |
|
(optional) A filter to return only resources that match the entire display name given. |
|
(optional) A unique identifier for the backup. |
|
(optional) A unique identifier for the database system. |
|
(optional) The maximum number of items to return. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timeCreated is descending. Default order for displayName is ascending. Allowed values are: 'timeCreated', 'displayName' |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_CONFIGURATIONS Function
Returns a list of configurations.
Syntax
FUNCTION list_configurations (
compartment_id varchar2 DEFAULT NULL,
lifecycle_state varchar2 DEFAULT NULL,
display_name varchar2 DEFAULT NULL,
db_version varchar2 DEFAULT NULL,
shape varchar2 DEFAULT NULL,
configuration_id varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
page varchar2 DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_configurations_response_t;
Parameters
Parameter | Description |
---|---|
|
(optional) The ID of the compartment in which to list resources. |
|
(optional) A filter to return only resources if their `lifecycleState` matches the given `lifecycleState`. |
|
(optional) A filter to return only resources that match the entire display name given. |
|
(optional) Verison of the PostgreSQL database, such as 14.9. |
|
(optional) The name of the shape for the configuration. Example: `VM.Standard.E4.Flex` |
|
(optional) A unique identifier for the configuration. |
|
(optional) The maximum number of items to return. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timeCreated is descending. Default order for displayName is ascending. Allowed values are: 'timeCreated', 'displayName' |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_DB_SYSTEMS Function
Returns a list of database systems.
Syntax
FUNCTION list_db_systems (
compartment_id varchar2 DEFAULT NULL,
lifecycle_state varchar2 DEFAULT NULL,
display_name varchar2 DEFAULT NULL,
id varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
page varchar2 DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_db_systems_response_t;
Parameters
Parameter | Description |
---|---|
|
(optional) The ID of the compartment in which to list resources. |
|
(optional) A filter to return only resources if their `lifecycleState` matches the given `lifecycleState`. |
|
(optional) A filter to return only resources that match the entire display name given. |
|
(optional) A unique identifier for the database system. |
|
(optional) The maximum number of items to return. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timeCreated is descending. Default order for displayName is ascending. Allowed values are: 'timeCreated', 'displayName' |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_DEFAULT_CONFIGURATIONS Function
Returns a list of default configurations.
Syntax
FUNCTION list_default_configurations (
lifecycle_state varchar2 DEFAULT NULL,
display_name varchar2 DEFAULT NULL,
db_version varchar2 DEFAULT NULL,
shape varchar2 DEFAULT NULL,
configuration_id varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
page varchar2 DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_default_configurations_response_t;
Parameters
Parameter | Description |
---|---|
|
(optional) A filter to return only resources if their `lifecycleState` matches the given `lifecycleState`. |
|
(optional) A filter to return only resources that match the entire display name given. |
|
(optional) Verison of the PostgreSQL database, such as 14.9. |
|
(optional) The name of the shape for the configuration. Example: `VM.Standard.E4.Flex` |
|
(optional) A unique identifier for the configuration. |
|
(optional) The maximum number of items to return. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timeCreated is descending. Default order for displayName is ascending. Allowed values are: 'timeCreated', 'displayName' |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_SHAPES Function
Returns the list of shapes allowed in the region.
Syntax
FUNCTION list_shapes (
compartment_id varchar2 DEFAULT NULL,
id varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
page varchar2 DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_shapes_response_t;
Parameters
Parameter | Description |
---|---|
|
(optional) The ID of the compartment in which to list resources. |
|
(optional) A filter to return the feature by the shape name. |
|
(optional) The client request ID for tracing. |
|
(optional) The maximum number of items to return. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timeCreated is descending. Default order for displayName is ascending. Allowed values are: 'timeCreated', 'displayName' |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_WORK_REQUEST_ERRORS Function
Returns a (paginated) list of errors for the work request with the given ID.
Syntax
FUNCTION list_work_request_errors (
work_request_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
page varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_work_request_errors_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) The ID of the asynchronous request. |
|
(optional) The client request ID for tracing. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The maximum number of items to return. |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timestamp is descending. Allowed values are: 'timestamp' |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_WORK_REQUEST_LOGS Function
Returns a (paginated) list of logs for the work request with the given ID.
Syntax
FUNCTION list_work_request_logs (
work_request_id varchar2,
opc_request_id varchar2 DEFAULT NULL,
page varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_work_request_logs_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) The ID of the asynchronous request. |
|
(optional) The client request ID for tracing. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The maximum number of items to return. |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timestamp is descending. Allowed values are: 'timestamp' |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
LIST_WORK_REQUESTS Function
Lists the work requests in a compartment.
Syntax
FUNCTION list_work_requests (
compartment_id varchar2 DEFAULT NULL,
work_request_id varchar2 DEFAULT NULL,
status varchar2 DEFAULT NULL,
resource_id varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
page varchar2 DEFAULT NULL,
limit number DEFAULT NULL,
sort_order varchar2 DEFAULT NULL,
sort_by varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_list_work_requests_response_t;
Parameters
Parameter | Description |
---|---|
|
(optional) The ID of the compartment in which to list resources. |
|
(optional) The ID of the asynchronous work request. |
|
(optional) A filter to return only resources if their `lifecycleState` matches the given OperationStatus. Allowed values are: 'ACCEPTED', 'IN_PROGRESS', 'WAITING', 'FAILED', 'SUCCEEDED', 'CANCELING', 'CANCELED' |
|
(optional) The ID of the resource affected by the request. |
|
(optional) The client request ID for tracing. |
|
(optional) A token representing the position at which to start retrieving results. This must come from the `opc-next-page` header field of a previous response. |
|
(optional) The maximum number of items to return. |
|
(optional) The sort order to use, either 'ASC' or 'DESC'. Allowed values are: 'ASC', 'DESC' |
|
(optional) The field to sort by. Only one sort order may be provided. Default order for timeAccepted is descending. Allowed values are: 'timeAccepted' |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
PATCH_DB_SYSTEM Function
Modifies the database system by adding or removing database instance nodes.
Syntax
FUNCTION patch_db_system (
db_system_id varchar2,
patch_db_system_details dbms_cloud_oci_psql_patch_db_system_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_patch_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) The information to be modified. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
RESET_MASTER_USER_PASSWORD Function
Resets the database system's master password.
Syntax
FUNCTION reset_master_user_password (
db_system_id varchar2,
reset_master_user_password_details dbms_cloud_oci_psql_reset_master_user_password_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_reset_master_user_password_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) The information to be updated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
RESTART_DB_INSTANCE_IN_DB_SYSTEM Function
Restarts the running database instance node.
Syntax
FUNCTION restart_db_instance_in_db_system (
db_system_id varchar2,
restart_db_instance_in_db_system_details dbms_cloud_oci_psql_restart_db_instance_in_db_system_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_restart_db_instance_in_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) Database instance node restart parameters. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
RESTORE_DB_SYSTEM Function
Restore the database system.
Syntax
FUNCTION restore_db_system (
db_system_id varchar2,
restore_db_system_details dbms_cloud_oci_psql_restore_db_system_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_restore_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) Database system restore parameters. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
UPDATE_BACKUP Function
Updates the backup.
Syntax
FUNCTION update_backup (
backup_id varchar2,
update_backup_details dbms_cloud_oci_psql_update_backup_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_update_backup_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the backup. |
|
(required) The information to be updated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
UPDATE_CONFIGURATION Function
Updates a display name or description of the configuration.
Syntax
FUNCTION update_configuration (
configuration_id varchar2,
update_configuration_details dbms_cloud_oci_psql_update_configuration_details_t,
opc_retry_token varchar2 DEFAULT NULL,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_update_configuration_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the configuration. |
|
(required) Details for updating display name or description for a configuration. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
UPDATE_DB_SYSTEM Function
Updates the database system.
Syntax
FUNCTION update_db_system (
db_system_id varchar2,
update_db_system_details dbms_cloud_oci_psql_update_db_system_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_update_db_system_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) The information to be updated. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |
UPDATE_DB_SYSTEM_DB_INSTANCE Function
Updates the database instance node.
Syntax
FUNCTION update_db_system_db_instance (
db_system_id varchar2,
db_instance_id varchar2,
update_db_system_db_instance_details dbms_cloud_oci_psql_update_db_system_db_instance_details_t,
if_match varchar2 DEFAULT NULL,
opc_request_id varchar2 DEFAULT NULL,
opc_retry_token varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_psql_postgresql_update_db_system_db_instance_response_t;
Parameters
Parameter | Description |
---|---|
|
(required) A unique identifier for the database system. |
|
(required) A unique identifier for the database instance node. |
|
(required) Database instance node update parameters. |
|
(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
|
(optional) The client request ID for tracing. |
|
(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, `retrytoken` could be expired or invalidated. |
|
(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix). |
|
(optional) The endpoint of the service to call using this function. e.g https://postgresql.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence. |
|
(optional) The name of the credential for authenticating with the corresponding cloud native API. |