Pygresql update#

Pygresql update#

Database wrapper class: DB pkey - returns the primary key of a table get_databases - get list of databases in the system get_tables - get list of tables in connected database get_attnames - returns the attribute names of a table get - get a tuple from a database table insert - insert a tuple into a database table update - update a database table clear - clear a database table delete - deletes the row from a table 9.5. Connection object: pgobject query - executes a SQL command reset - resets the connection close - close the database connection fileno - returns the socket used to connect to the database getnotify - gets the last notify from the server inserttable - inserts a list into a table putline - writes a line to the server socket getline - gets a line from server socket endcopy - synchronizes client and server locreate - creates of large object in the database getlo - builds a large object from given oid loimport - imports a file to a PostgreSQL large object 9.4. pg Module Functions connect - opens a connection to the database server get_defhost - get default host name set_defhost - set default host name get_defport - get default port set_defport - set default port get_defopt - get default options specification set_defopt - set options specification get_deftty - get default connection debug terminal specification set_deftty - set default debug terminal specification get_defbase - get default database name specification set_defbase - set default database name specification 9.3.