postgres.update.process_sql

postgres.update.process_sql(
    sql,
    *,
    user=None,
    host=None,
    dbname=None,
    port=None,
    params=None,
)

Execute SQL against the destination PostgreSQL database used by wrds_update_pg() by default.

Parameters

Name	Type	Description	Default
sql	str	SQL statement to execute.	required
user	str	PostgreSQL user role.	`None`
host	str	PostgreSQL host name.	`None`
dbname	str	PostgreSQL database name.	`None`
port	int	PostgreSQL port.	`None`
params	sequence or mapping	Parameters passed to `cursor.execute()`.	`None`

Name	Type	Description
	str	Psycopg `statusmessage` for the executed statement.