CREATE SERVER

Function

CREATE SERVER defines a new foreign server. The current feature is a lab feature. Contact Huawei technical support before using it.

Precautions

When multi-layer quotation marks are used for sensitive columns (such as password and secret_access_key) in OPTIONS, the semantics is different from that in the scenario where quotation marks are not used. Therefore, sensitive columns are not identified for anonymization.

Syntax

CREATE SERVER server_name
    FOREIGN DATA WRAPPER fdw_name
    OPTIONS ( { option_name ' value ' } [, ...] ) ;

Parameter Description

• server_name

  Specifies the server name.

  Value range: a string containing no more than 63 characters

• fdw_name

  Specifies the name of the foreign data wrapper.

  Value range: dist_fdw, log_fdw, and file_fdw

• OPTIONS ( { option_name ' value ' } [, ...] )

  Specifies options for the server. These options typically define the connection details of the server, but the actual names and values depend on the foreign data wrapper of the server.

  • Specifies the parameters for the foreign server. The detailed parameter description is as follows:
    • encrypt

      Specifies whether data is encrypted. This parameter is available only when type is OBS. The default value is on.

      Value range:

      • on indicates that data is encrypted and HTTPS is used for communication.
      • off indicates that data is not encrypted and HTTP is used for communication.
    • access_key

      Specifies the access key (AK) (obtained by users from the OBS console) used for the OBS access protocol. When you create a foreign table, the AK value is encrypted and saved to the metadata table of the database. This parameter is available only when type is set to OBS.

    • secret_access_key

      Specifies the secret key (SK) value (obtained by users from the OBS console) used for the OBS access protocol. When you create a foreign table, the SK value is encrypted and saved to the metadata table of the database. This parameter is available only when type is set to OBS.

Examples

Create a server.

openGauss=* create server my_server foreign data wrapper log_fdw;
CREATE SERVER

Helpful Links

ALTER SERVER and DROP SERVER