ForĬhanged in version 2.3: namedtuple instances are adapted like regular tuples andĬan thus be used to represent composite types. Passing a sequence of values as the second argument of the function. Passing parameters to an SQL statement happens in functions such asĬursor.execute() by using %s placeholders in the SQL statement, and Many standard Python types areĪlready adapted to the correct SQL representation. Type determines the function used to convert the object into a string Psycopg converts Python variables to SQL values using their types: the Python Using methods such as fetchone(), fetchmany(), Retrieve data from the database by iteration or

Send commands to the database using methods such as execute() The class cursor allows interaction with the database: Terminate transactions using the methods commit() or It allows to:Ĭreate new cursor instances using the cursor() method to The class connection encapsulates a database session. The function connect() creates a new database session and commit () # Close communication with the database > cur. fetchone () (1, 100, 'abc'def') # Make the changes to the database persistent > conn. ( 100, 'abc'def' )) # Query the database and obtain data as Python objects > cur. execute ( 'INSERT INTO test (num, data) VALUES ( %s, %s )'. execute ( 'CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar) ' ) # Pass data to fill a query placeholders and let Psycopg perform # the correct conversion (no more SQL injections!) > cur. cursor () # Execute a command: this creates a new table > cur. connect ( 'dbname=test user=postgres' ) # Open a cursor to perform database operations > cur = conn. import psycopg2 # Connect to an existing database > conn = psycopg2.

Postgres not like