Script Development / PostgreSQL

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

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

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

`.query(...)`

Executes an SQL statement, with parameters as follows:

Parameter	Type	Required / Default Value	Description
`sql`	str	Required	SQL statement, may 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)

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

For example, when there is an uncertain number of values in WHERE IN (...), or performing bulk data insertion using INSERT INTO ... VALUES ....