Script Development / PostgreSQL

The PostgreSQL connector operation object primarily provides some methods for operating on PostgreSQL. This connector supports the following databases:

Greenplum Database
Alibaba Cloud PolarDB MySQL
Alibaba Cloud Analytic Database (ADB) PostgreSQL Edition

DFF.CONN(...) parameters are as follows:

Parameter	Type	Required / Default Value	Description
`connector_id`	str	Required	Connector ID
`database`	str	`None`	Specify database

`.query(...)`

Execute SQL statements, parameters are as follows:

Parameter	Type	Required / Default Value	Description
`sql`	str	Required	SQL statement, can include parameter placeholders. `?` indicates an escaped parameter; `??` indicates a non-escaped parameter
`sql_params`	list	`None`	SQL parameters

Example
sql = 'SELECT * FROM ?? WHERE seq > ?'
sql_params = ['demo', 1]
result = db.query(sql, sql_params=sql_params)

Dynamic SQL Statements

query(...) and non_query(...) internally use DFF.SQL(...) to construct SQL statements and support building complex dynamic SQL statements.

For example, WHERE IN (...) with an uncertain number of values, or performing bulk data writes using INSERT INTO ... VALUES ....

For more details, please refer to Script Development / SQL Construction DFF.SQL