insert a new vendor INSERT INTO vendors(vendor_name) CREATE OR REPLACE PROCEDURE add_new_part(īEGIN - insert into the parts table INSERT INTO parts(part_name) cur.close()Ĭonn.close() Code language: Python ( python ) Calling a stored procedure exampleįirst, create the following add_new_part() stored procedure in the suppliers database. If you stored procedure does not accept any parameters, you can omit the second argument like this: cur.execute( "CALL sp_name) ") Code language: Python ( python )Īfter that, call the commit() method to commit the transaction: mit() Code language: Python ( python )įinally, call the close() method of the cursor and connection objects to close the connection to the PostgreSQL database server. For example: cur.execute( "CALL sp_name(%s, %s) ", (val1, val2)) Code language: Python ( python ) Then, pass the name of the stored procedure and the optional input values to the execute() method of the cursor object. cur = conn.cursor() Code language: Python ( python ) Next, create a new cursor by calling the cursor() method of the connection object. The connect() method returns a new instance of the connection class. To call a PostgreSQL stored procedure in a Python program, you follow thế steps:įirst, create a new database connection to the PostgreSQL database server by calling the connect() function: conn = nnect(dsn) Code language: Python ( python )
Steps for calling a PostgreSQL stored procedure in Python
Stored procedure in aws postgresql how to#
Summary: in this tutorial, you will learn how to call PostgreSQL stored procedures from a Python program.
0 kommentar(er)
