python-psycopg2-doc 2.6.1-1build2 / usr / share / doc / python-psycopg2-doc / html / searchindex.js

Search.setIndex({envversion:46,filenames:["advanced","connection","cursor","errorcodes","extensions","extras","faq","index","install","module","news","pool","tz","usage"],objects:{"":{connection:[1,0,1,""],cursor:[2,0,1,""],psycopg2:[9,3,0,"-"]},"psycopg2.Error":{cursor:[9,1,1,""],diag:[9,1,1,""],pgcode:[9,1,1,""],pgerror:[9,1,1,""]},"psycopg2.extensions":{AsIs:[4,0,1,""],BINARYARRAY:[4,4,1,""],BOOLEAN:[4,4,1,""],BOOLEANARRAY:[4,4,1,""],Binary:[4,0,1,""],Boolean:[4,0,1,""],DATE:[4,4,1,""],DATEARRAY:[4,4,1,""],DATETIMEARRAY:[4,4,1,""],DECIMAL:[4,4,1,""],DECIMALARRAY:[4,4,1,""],DateFromMx:[4,0,1,""],DateFromPy:[4,0,1,""],FLOAT:[4,4,1,""],FLOATARRAY:[4,4,1,""],Float:[4,0,1,""],INTEGER:[4,4,1,""],INTEGERARRAY:[4,4,1,""],INTERVAL:[4,4,1,""],INTERVALARRAY:[4,4,1,""],ISOLATION_LEVEL_AUTOCOMMIT:[4,4,1,""],ISOLATION_LEVEL_READ_COMMITTED:[4,4,1,""],ISOLATION_LEVEL_READ_UNCOMMITTED:[4,4,1,""],ISOLATION_LEVEL_REPEATABLE_READ:[4,4,1,""],ISOLATION_LEVEL_SERIALIZABLE:[4,4,1,""],ISQLQuote:[4,0,1,""],IntervalFromMx:[4,0,1,""],IntervalFromPy:[4,0,1,""],LONGINTEGER:[4,4,1,""],LONGINTEGERARRAY:[4,4,1,""],MXDATE:[4,4,1,""],MXDATEARRAY:[4,4,1,""],MXDATETIME:[4,4,1,""],MXDATETIMEARRAY:[4,4,1,""],MXINTERVAL:[4,4,1,""],MXINTERVALARRAY:[4,4,1,""],MXTIME:[4,4,1,""],MXTIMEARRAY:[4,4,1,""],POLL_ERROR:[4,4,1,""],POLL_OK:[4,4,1,""],POLL_READ:[4,4,1,""],POLL_WRITE:[4,4,1,""],PYDATE:[4,4,1,""],PYDATEARRAY:[4,4,1,""],PYDATETIME:[4,4,1,""],PYDATETIMEARRAY:[4,4,1,""],PYINTERVAL:[4,4,1,""],PYINTERVALARRAY:[4,4,1,""],PYTIME:[4,4,1,""],PYTIMEARRAY:[4,4,1,""],QueryCanceledError:[4,6,1,""],QuotedString:[4,0,1,""],ROWIDARRAY:[4,4,1,""],SQL_IN:[4,0,1,""],STATUS_BEGIN:[4,4,1,""],STATUS_IN_TRANSACTION:[4,4,1,""],STATUS_PREPARED:[4,4,1,""],STATUS_READY:[4,4,1,""],STRINGARRAY:[4,4,1,""],TIME:[4,4,1,""],TIMEARRAY:[4,4,1,""],TRANSACTION_STATUS_ACTIVE:[4,4,1,""],TRANSACTION_STATUS_IDLE:[4,4,1,""],TRANSACTION_STATUS_INERROR:[4,4,1,""],TRANSACTION_STATUS_INTRANS:[4,4,1,""],TRANSACTION_STATUS_UNKNOWN:[4,4,1,""],TimeFromMx:[4,0,1,""],TimeFromPy:[4,0,1,""],TimestampFromMx:[4,0,1,""],TimestampFromPy:[4,0,1,""],TransactionRollbackError:[4,6,1,""],UNICODE:[4,4,1,""],UNICODEARRAY:[4,4,1,""],adapt:[4,5,1,""],adapters:[4,4,1,""],connection:[4,0,1,""],cursor:[4,0,1,""],encodings:[4,4,1,""],lobject:[4,0,1,""],new_array_type:[4,5,1,""],new_type:[4,5,1,""],register_adapter:[4,5,1,""],register_type:[4,5,1,""],string_types:[4,4,1,""]},"psycopg2.extensions.AsIs":{getquoted:[4,2,1,""]},"psycopg2.extensions.Binary":{getquoted:[4,2,1,""]},"psycopg2.extensions.ISQLQuote":{"_wrapped":[4,1,1,""],getquoted:[4,2,1,""],prepare:[4,2,1,""]},"psycopg2.extensions.QuotedString":{getquoted:[4,2,1,""]},"psycopg2.extensions.lobject":{"export":[4,2,1,""],close:[4,2,1,""],closed:[4,1,1,""],mode:[4,1,1,""],oid:[4,1,1,""],read:[4,2,1,""],seek:[4,2,1,""],tell:[4,2,1,""],truncate:[4,2,1,""],unlink:[4,2,1,""],write:[4,2,1,""]},"psycopg2.pool":{AbstractConnectionPool:[11,0,1,""]},"psycopg2.pool.AbstractConnectionPool":{closeall:[11,2,1,""],getconn:[11,2,1,""],putconn:[11,2,1,""]},connection:{async:[1,1,1,""],autocommit:[1,1,1,""],cancel:[1,2,1,""],close:[1,2,1,""],closed:[1,1,1,""],commit:[1,2,1,""],cursor:[1,2,1,""],cursor_factory:[1,1,1,""],dsn:[1,1,1,""],encoding:[1,1,1,""],fileno:[1,2,1,""],get_backend_pid:[1,2,1,""],get_parameter_status:[1,2,1,""],get_transaction_status:[1,2,1,""],isexecuting:[1,2,1,""],isolation_level:[1,1,1,""],lobject:[1,2,1,""],notices:[1,1,1,""],notifies:[1,1,1,""],poll:[1,2,1,""],protocol_version:[1,1,1,""],reset:[1,2,1,""],rollback:[1,2,1,""],server_version:[1,1,1,""],set_client_encoding:[1,2,1,""],set_isolation_level:[1,2,1,""],set_session:[1,2,1,""],status:[1,1,1,""],tpc_begin:[1,2,1,""],tpc_commit:[1,2,1,""],tpc_prepare:[1,2,1,""],tpc_recover:[1,2,1,""],tpc_rollback:[1,2,1,""],xid:[1,2,1,""]},cursor:{arraysize:[2,1,1,""],callproc:[2,2,1,""],cast:[2,2,1,""],close:[2,2,1,""],closed:[2,1,1,""],connection:[2,1,1,""],copy_expert:[2,2,1,""],copy_from:[2,2,1,""],copy_to:[2,2,1,""],description:[2,1,1,""],execute:[2,2,1,""],executemany:[2,2,1,""],fetchall:[2,2,1,""],fetchmany:[2,2,1,""],fetchone:[2,2,1,""],itersize:[2,1,1,""],lastrowid:[2,1,1,""],mogrify:[2,2,1,""],name:[2,1,1,""],nextset:[2,2,1,""],query:[2,1,1,""],rowcount:[2,1,1,""],rownumber:[2,1,1,""],scroll:[2,2,1,""],scrollable:[2,1,1,""],setinputsizes:[2,2,1,""],setoutputsize:[2,2,1,""],statusmessage:[2,1,1,""],tzinfo_factory:[2,1,1,""],withhold:[2,1,1,""]},psycopg2:{BINARY:[9,4,1,""],Binary:[9,5,1,""],DATETIME:[9,4,1,""],DataError:[9,6,1,""],DatabaseError:[9,6,1,""],Date:[9,5,1,""],DateFromTicks:[9,5,1,""],Error:[9,6,1,""],IntegrityError:[9,6,1,""],InterfaceError:[9,6,1,""],InternalError:[9,6,1,""],NUMBER:[9,4,1,""],NotSupportedError:[9,6,1,""],OperationalError:[9,6,1,""],ProgrammingError:[9,6,1,""],ROWID:[9,4,1,""],STRING:[9,4,1,""],Time:[9,5,1,""],TimeFromTicks:[9,5,1,""],Timestamp:[9,5,1,""],TimestampFromTicks:[9,5,1,""],Warning:[9,6,1,""],apilevel:[9,4,1,""],connect:[9,5,1,""],errorcodes:[3,3,0,"-"],extensions:[4,3,0,"-"],extras:[5,3,0,"-"],paramstyle:[9,4,1,""],pool:[11,3,0,"-"],threadsafety:[9,4,1,""],tz:[12,3,0,"-"]}},objnames:{"0":["py","class","Python class"],"1":["py","attribute","Python attribute"],"2":["py","method","Python method"],"3":["py","module","Python module"],"4":["py","data","Python data"],"5":["py","function","Python function"],"6":["py","exception","Python exception"]},objtypes:{"0":"py:class","1":"py:attribute","2":"py:method","3":"py:module","4":"py:data","5":"py:function","6":"py:exception"},terms:{"08t01":13,"100kb":13,"10l":13,"2gb":[4,10,13],"42p01":[3,9],"4ef8":5,"6bb9bd380a11":5,"9c0b":5,"\u00e0\u00e8\u00ec\u00f2\u00f9":13,"__class__":0,"__conform__":0,"__gcc__":10,"__init__":[0,13],"__iter__":10,"__name__":0,"__slots__":10,"__version__":13,"_psycopg":[4,5,6,8,10],"_without_":10,"_wrap":4,"boolean":[2,4,13],"break":[0,10],"byte":[0,1,2,4,10,13],"case":[0,1,2,4,8,9,10,13],"catch":[2,9],"char":[4,9],"class":0,"default":[1,2,4,5,6,9,10,13],"enum":4,"export":[1,2,4,8,9,10,13],"float":[0,4,5,6,10,13],"function":[0,1,2],"import":[0,1,2,4,5,6,8,9,10,13],"int":[5,10,13],"long":[1,6,9,10,13],"na\u00efv":13,"null":[0,2,4,10,13],"public":10,"return":[0,1,2,4,5,6,8,9,10,13],"static":10,"switch":[0,1,10],"true":[0,1,2,6,9,11,13],"try":[0,1,2,6,8,9,10,13],"while":[0,3,4,9,10,13],a0eebc99:5,a_dat:13,a_str:13,abc:[2,5,13],abl:[3,4,13],abort:[6,13],about:[0,1,2,4,8,9,10,11,13],abov:[0,1,8,13],absolut:2,abstractconnectionpool:11,accept:[0,1,4,10,13],access:[1,4,5,7,10],accord:[0,1,2,3,4,13],accordingli:[8,9,10],account:10,accur:9,aconn:0,across:[3,6,10],action:[1,13],activ:[10,13],actual:[2,4,10],acur:0,adam:10,adapt_point:0,add:[4,8,10],addit:[1,3],addr:5,address:[4,9],adjust:8,advantag:[0,6,9],advic:2,advis:0,affect:[2,9,13],after:[0,1,2,4,5,6,8,10,13],again:[8,10],against:[2,4,8,13],aim:10,alexei:10,algorithm:1,alia:[1,4,13],all:[0,1,2,3,4,5,6,8,9,10,11,13],alloc:[9,10,13],allow:[0,1,2,4,5,8,10,13],almost:[6,10],alon:10,alphanumer:1,alreadi:[1,4,8,9,10,13],also:[0,1,2,3,4,5,6,8,9,10,13],altern:[5,6,8,13],alwai:[0,2,4,6,10,13],among:1,amount:13,an_int:13,analysi:10,ani:[0,1,2,4,5,6,8,9,10,13],another_d:13,anticip:10,anymor:[6,9,10,13],anyth:[6,13],anywai:[5,10],apapt:10,api:0,apilevel:9,apoint:0,app:10,appear:[4,13],append:[1,2,13],appli:[1,10,13],applic:[0,2,3,4,7,9,11],approach:13,appropri:[10,13],apt:8,arbitrari:10,arch:10,archflag:8,architectur:10,arg:[0,11],argument:[0,1,2,4,5,6,8,9,10,12,13],around:10,arrai:[0,4,5,6,10,13],array_oid:6,arrays:2,arriv:0,asi:[0,4,10],asia:13,asp:6,asprintf:10,assert:10,assign:[1,3,11,13],assist:10,associ:[2,13],assum:[2,5,13],async:[0,1,4,9,10],atabl:0,attack:13,attempt:[0,1,2],attnam:5,attribut:[0,1,2,3,4,9,10,12,13],authent:9,author:[0,1,13],autocommit:[0,1,6,10,13],automat:[0,1,2,4,5,6,10,11,13],autotool:10,avail:[0,1,2,3,4,5,6,8,9,10,13],avoid:[0,1,6,8,10],awai:11,awaken:0,back:[1,5,10,13],backend:[1,2,4,6,9,10,13],backslash:[4,10],backward:[1,2,10,13],bad:[0,4,10],bar:[2,6,13],barf:9,base:[0,2,4,8,9,10,11],base_cast:4,basic:[0,4,7,9],basicconfig:10,bb6d:5,bdist_rpm:10,becaus:[0,6,13],becom:0,been:[0,1,2,3,4,5,10,13],befor:[0,1,2,4,6,8,10,13],began:4,begin:[0,1,10,13],behav:[1,4,10,13],behavior:5,behaviour:[1,4,10],belong:1,below:[1,4,9],best:2,better:[0,5,10],between:[0,1,3,5,9,10,13],bidirect:13,big:10,bigint:13,bin:8,binari:[4,6,9,10],binaryarrai:4,bind:[0,2,9,10,13],bit:[4,6,10,13],blake:10,bloat:[1,13],blob:[9,13],block:[0,1,2,4,6,10,13],blog:8,blue:5,bodi:2,boil:0,bool:13,booleanarrai:4,borrow:3,borzenkov:10,both:[1,2,7,10,13],bother:[0,8],bound:[2,9,10,13],box:[5,7],bqual:1,branch:13,broken:[1,10],brought:10,brows:10,browser:10,btree:5,buffer:[2,10,13],bug:[8,10],bugfix:10,buglet:10,build:[0,7],build_ext:8,built:[4,6,10,13],builtin:[1,4,5,10,13],bunch:6,button:1,bux:10,bytea:[6,10,13],bytea_output:[6,13],bytearrai:[10,13],cach:6,calcul:10,calcutta:13,call:[0,1,2,4,6,8,9,10,13],callabl:9,callback:[0,10],caller:0,callproc:[0,2,10,13],can:[0,1,2,3,4,5,6,7,8,9,10,11,12,13],cancel:[1,4,10],cannot:[2,6,9,13],capabl:[2,9],capac:5,card:5,card_back:5,care:[5,13],carri:0,cast_point:0,caster:[4,10],catalog:[0,4],caus:[1,4,10],cento:10,certain:10,cfg:[8,10],chang:[0,1,2,3,4,5,6,9,10,13],changelog:10,channel:[0,1],charact:[1,2,3,13],characterist:1,check:[0,5,8,9,10],child:6,choic:8,choos:1,chosen:10,chri:10,chunk:[4,6],citizen:10,class_syntax_error_or_access_rule_viol:3,classic:10,clean:10,cleanup:10,click:8,client:[0,1,2,4,6,7,8,9,10,11,13],client_encod:1,client_min_messag:1,clobber:[5,10],close:[1,2,4,6,10,11,13],closeal:11,code:[0,2],codebas:10,codec:[4,13],col:13,collect:[2,5,10],column:[0,1,2,5,9,10,13],com:10,come:[0,13],comma:[6,13],command:[0,1,2,4,5,6,8,10,13],commit:[0,1,2,4,6,7,10],common:[10,13],commun:[0,1,4,7,10,13],compani:10,compar:9,comparison:10,compat:[0,1,5,8,10],compil:[2,4],complain:8,complet:[0,4,7,9,10,13],complex:4,complianc:[2,4,9],compon:[4,5,13],compos:[1,2],compositecast:5,computation:2,con:4,concaten:13,concurr:[0,1,4,6,7,10],condit:[1,3,4,6,10,13],config:8,configur:[1,4,8,10,13],conform:[0,4],conn:[0,1,4,5,9,11,13],conn_get_isolation_level:10,connection_factori:[4,5,9,10],connecton:1,consecut:10,consid:[1,9,10],consider:2,consist:[4,10],constant:[1,3],constraint:1,construct:9,constructor:[4,7],consum:13,contain:[0,1,2,3,4,8,9,10,13],content:[2,4,7],context:[2,10,13],contidion:13,continu:13,contit:13,control:[0,1,4,7,9],conveni:[0,13],convent:3,convers:[0,4,5],convert:[0,1,2,4,5,6,9,10,13],cooper:0,copi:[0,2,5,7,8,9,10],copiou:8,copy_expert:[2,13],copy_from:[2,10,13],copy_in:10,copy_to:[2,10,13],core:10,correct:[6,8,10,13],correctli:[1,10,13],corri:10,corrupt:10,could:[0,1,4,9,10,13],count:[2,10],coupl:10,cours:[0,13],cpu:0,cpython:8,craft:13,crash:10,creat:[0,1,2,4,5,6,7],creation:10,csv:2,ctype:8,cupcic:10,cur1:13,cur2:13,cur:[0,1,2,4,5,6,9,13],curnam:13,current:[0,1,2,4,6,7,8,9],cursor_factori:[0,1,4,5,9,10],custom:[0,5,6,7,9,10],customiz:13,dada:2,dai:[9,13],daniel:10,data:[0,1,2,4],databas:[0,1,2,3],databaseerror:[9,10],dataerror:9,dataset:13,date:[4,5,9,10],datearrai:4,datefrommx:4,datefrompi:[4,13],datefromtick:9,daterang:5,datestyl:[1,10],datetim:[4,8,9,10,12,13],datetimearrai:4,datetimedelta:10,dave:10,david:10,dbapi20:10,dbapi:[1,10],dbname:[9,13],deadlock:[0,4,10],deal:[4,5,10,13],deal_with_it:2,dealloc:10,dealt:2,deb:8,debian:[8,10],debug:7,dec2float:6,decid:2,decim:[1,2,4,5,6,10,13],decimalarrai:4,declar:[1,2,10,13],decod:[1,2,4,10,13],decreas:13,def:[0,2,5,13],default_transaction_:[0,1],default_transaction_deferr:1,default_transaction_isol:1,default_transaction_read_onli:1,deferr:[1,10],defin:[0,1],del:[1,2,13],deleg:0,delimit:13,denot:3,depend:[0,2,4,5,6,8,10],deprec:10,derefer:10,describ:[2,9,10],descript:[0,2,4,9,10],descriptor:[0,1,4],deserv:10,design:[0,7],desir:4,desk:13,destin:9,destroi:[7,10,13],destruct:13,detail:[0,1,2,4,6,8,9,10,13],detect:[4,9,10],determin:2,dev:[6,8],devel:10,develop:[6,10],diag:9,diagnosi:10,diagnost:[8,9,10],dict:[5,10,13],dict_cur:5,dictcomposit:5,dictcursor:[5,10],dictionari:4,dictrow:10,did:[1,2,10],differ:[0,1,2,4,5,8,9,10,12,13],digit:[1,2],direct:6,directli:[0,11,12],directori:[6,8,10],disabl:5,disadvantag:6,discard:[1,2,6,10,11],disconnect:[9,10],discuss:10,dislik:10,displai:10,display_s:2,dispos:6,distinct:4,distribut:[5,8,10,13],divis:9,django:10,dml:2,doc:[1,10],docstr:10,document:[0,1,2,3,4,6,8,9,10,13],doe:[0,1,2,3,4,6,9,10],doesn:[0,2,5,6,9,10,13],don:[1,8,10,13],done:[2,5,8],doubl:[2,4,8,10,13],down:0,download:[5,8],dql:2,driver:[1,13],drop:10,dsn:[0,1,4,9,10,13],due:[2,3,4,9],dump:5,dunklau:10,dure:[1,2,4,6,9,10,13],dynam:[4,6,8],each:[2,4,6,9,10,13],earlier:6,eas:13,easi:[0,2,6,8,10],easiest:6,easili:13,easy_instal:[6,8],ecosystem:10,edit:8,effect:[1,2,4,5,13],effici:[4,5,7,10,13],egenix:13,egg:6,eisentraut:10,either:[0,1,2,4,5,9,10,13],element:[10,13],elif:[0,13],els:[0,6,13],embed:5,emerton:10,emit:[3,8,13],emploi:13,empti:[0,2,10,13],enabl:[0,5,10,13],enc:1,encapsul:[1,13],enclos:4,encod:[1,2,4,10,13],encount:[6,9],end:[0,1,2,6,13],enough:[4,10],ensur:[1,10],entir:[0,2,13],entri:[2,4,6,13],env:6,environ:[0,8,9,10],epoch:9,epydoc:10,equal:[5,9],equival:[1,4],eric:10,erickson:8,error:[0,1],escap:[4,6,10,13],especi:8,establish:[0,1,4],etc:[1,4,5,9,10],euc_cn:10,euc_jis_2004:10,europ:13,even:[2,5,6,10,13],event:[6,10],eventlet:0,eventu:[1,11,13],ever:8,everi:[0,1,10,13],exactli:2,examin:13,exampl:[0,1,2,3,4,5,6,9,10,13],exc:[0,2],exce:13,except:[0,1,2],excess:1,exchang:13,exclus:9,execut:[0,1,2,4,5,6,8,9,10,13],executemani:[0,2,10,13],exist:[8,9,10,13],exit:[10,13],expand:0,expect:[2,4,5,9,10,11,13],expens:[10,11],experi:8,experiment:8,explain:1,explan:1,explicit:[1,6,10],explicitli:2,expos:[0,1,2,4,9,10,13],express:0,extend:[2,4,7,10,13],extens:0,extra:[0,1],extrem:13,face:5,facil:0,fail:[4,6,9,10,13],failur:[4,10],fairli:13,fall:13,fals:[1,2,4,9,11,13],faq:[4,5,8],fast:6,fastcgi:13,faster:10,fatal:10,favor:10,featur:[7,10,13],feel:6,fetch:[2,6,10,13],fetchal:[2,13],fetchmani:[2,6,10,13],fetchon:[0,2,5,13],fetchxxx:10,few:[0,2,4,5,6,8,9,10,11,13],fewer:2,field:[4,5,13],figur:8,file:[0,1,2,4,6,8,10,13],file_nam:4,fileno:[0,1,4,10],fill:[10,13],find:[4,6,10,13],fine:6,finer:1,finish:[1,4],fink:8,first:[0,1,3,4,6,10,13],fit:10,five:3,fix:10,fixedoffsettimezon:[10,13],flag:[8,13],flexibl:[2,4,7],floatarrai:4,flush:10,follow:[0,1,2,3,4,5,6,8,9,11,13],foo:[1,2,6,13],foo_id_seq:1,foo_pkei:1,forc:10,foreign:9,forget:[10,13],forgot:10,fork:[6,13],form:[0,1,2,13],format:[6,9,10,13],format_id:1,formula:6,forward:[1,2,6,13],found:[2,4,5,6,9,10],fraction:2,framework:0,free:[6,10,11],freed:10,freedom:0,friendli:[0,7],from:[0,1,2,3,4,5,6,7],fromtick:9,frontend:1,full:10,fulli:[8,10],fun:4,further:[0,1,6,9,13],furthermor:[1,13],futur:[0,2,6],gain:13,gangadharan:10,garbag:10,gcc:10,gener:[1,4,5,6,10,11,13],geometr:0,get:[0,2,6,8,10,11],get_backend_pid:[1,10],get_parameter_statu:[1,10],get_transaction_statu:[1,4,10],getconn:11,getlogg:0,getquot:[0,4,5,10,13],gevent:0,gil:10,gin:5,gist:5,git:10,github:10,give:0,given:[1,2,4,9,10],glitch:10,global:[1,4,5,6,8,13],gone:10,good:[6,10],googl:8,gori:[6,8],got:0,gotcha:6,great:13,greatli:[5,8],green:[0,10,13],grep:6,group:0,grumbl:10,gtrid:1,guarante:[1,4],guard:13,guess:10,gunpoint:13,hacker:10,had:[2,13],hain:10,hand:13,handl:[0,1,2,4,5],hang:13,happen:[0,1,10],harsh:[6,10],hat:10,have:[0,1,2,3,4,5,6,7],header:[2,8,10],heart:5,heavili:7,held:[1,13],hello:0,help:[8,10],helper:5,henc:2,here:[6,10,13],hex:[6,10,13],hilbert:10,hint:9,histor:13,hold:[1,4,5,9,10,12,13],honour:10,host:[1,9],hour:[9,13],how:[0,4,6,8,13],howev:[4,8,13],html:[1,10],http:10,huge:13,icon:10,identifi:[1,10,13],idl:[1,4,6,13],ignor:[6,10],illustr:8,immedi:[1,2,13],implement:[0,2,4,5,7,8,9,10,11],impli:13,implicit:[1,13],implicitli:[0,1,5,10],importerror:6,imposs:10,improv:[5,10],inappropri:1,includ:[1,2,3,4,8,10,11,13],inconsist:4,incorrectli:1,independ:8,index:[1,2,5,6,7,10],indexerror:2,indic:[2,3,7,8],inet:0,inf:10,infdateadapt:13,infer:3,infin:[5,10,13],infinit:5,info:[0,10],inform:[0,2,4,6,8,9,10],infrequ:10,ing:0,inherit:[9,10],init:10,initi:[1,6,10],inject:13,input:[2,9,13],insert:[0,2,5,6,7,9,10,13],insid:13,inspir:[4,13],instal:[1,6,7],instanc:[0,1,4,5,8,10,13],instant:10,instanti:1,instead:[0,2,4,5,6,9,10,13],integ:[1,4,6,9,10,13],integer_datetim:1,integerarrai:4,integr:9,integrityerror:9,intend:1,intens:2,interact:[0,10,13],interest:0,interfac:[0,2,5,9,10,13],interfaceerror:[0,1,2,9],intern:[4,9,10],internal_s:2,internalerror:9,interoper:13,interpol:13,interpret:10,interrupt:1,interv:[4,10,13],intervalarrai:4,intervalfrommx:4,intervalfrompi:4,introduc:10,introduct:7,introductori:1,invalid:[1,10],invent:3,invok:[0,1,2,4,10],involv:[2,5],iron:10,ironpython:8,is_superus:1,isbusi:10,isexecut:[0,1],ish:10,isn:10,iso885910:10,iso885916:10,iso:10,isol:[1,2],isolation_level:[1,4],isolation_level_autocommit:[0,1,4],isolation_level_read_commit:4,isolation_level_read_uncommit:4,isolation_level_repeatable_read:4,isolation_level_serializ:4,isqlquot:[0,4],isreadi:10,issu:[0,1,2,4,6,10,13],item:[1,2,4,6,9,13],iter:[2,10,13],iters:[2,10,13],itself:[0,2,9,13],jame:10,jan:10,jason:8,java:13,jdbc:[1,13],join:0,jon:10,jsonb:[5,6,10],jsondata:5,juggl:10,just:[4,8,10],jython:8,karsten:10,keep:[0,1,6,13],kei:[1,5,9,11,13],kept:1,kernel:0,keyword:[9,10],kind:[6,13],know:[0,3,4,9,10],known:[0,1,6,10,13],kreen:10,kudo:10,kwarg:[9,11],laci:10,lack:5,lambda:[5,6],languag:[5,7,8,13],larg:[0,1,2,4,6,7,9,10],larger:10,last:[1,2,3,5,10],lastrowid:[2,10],later:[4,10],latin10:10,latin9:13,latin:10,latter:[1,2],layer:10,layout:[9,10],lazi:10,ldd:[6,8],leak:[1,10],least:[6,10,13],leav:[2,6,10],left:[2,6,13],len:4,length:[2,10],less:[3,8,10],let:13,letter:2,level:[1,2],lib:8,libpq:[0,1,2,4,6,7,8,9,10,13],licens:10,lifetim:[2,13],lightweight:6,like:[2,3,4],limit:[0,4,9,10,13],line:[8,9,10,13],link:[8,10],linux:8,list:[0,1,2,4,6,8,9,10],listen:0,liter:[1,5,10,13],littl:[5,6,10],live:[1,6,13],lo64:13,lo_creat:10,lo_export:[4,13],lo_import:[1,13],lo_trunc:[4,6],lo_truncate64:6,load:[5,6,10],lobject:[1,4,10,13],lobject_factori:1,local:[1,3,8,10],locat:8,lock:[0,1,10,13],log:[0,1],log_min_duration_stat:1,log_stat:1,logger:0,loggingcursor:0,longer:[10,13],longinteg:4,longintegerarrai:4,look:[0,1,3,6,8,13],lookup:10,loop:[0,2,6,10],loss:[10,13],lost:[1,10],lot:[6,7,10],maa:10,mac:8,macaddr:4,macport:8,macro:10,made:[0,2,9,10,13],magic:6,mai:[0,1,2,4,6,8,9,13],mail:[8,10],main:[7,9,10,13],maintain:[0,8],major:1,make:[0,1,2,3,4,5,6,7,8,9,10,13],makefil:8,malcolm:10,malform:13,manag:1,mani:[0,1,2,4,5,7,8,9,10,13],manipul:[1,4,13],manner:[0,4],manu:10,manual:[0,1,10],map:[0,2,4,5,10,13],mark:10,marker:9,marko:10,marti:10,match:[0,2,4,7,8],matthew:10,matur:8,max:[5,13],maxconn:11,maximum:11,mayb:[0,10],mean:[1,2,6,10,13],meaning:10,mechan:[0,4,13],member:1,memo:13,memori:[6,9,10,13],memoryview:[10,13],menno:10,menu:10,merg:[10,13],mess:10,messag:[0,1,2,3,6,8,9,10],message_primari:9,met:[0,13],method:[0,1,2,4,5,6,9,10,11,13],microprotocol:10,microsoft:8,middlewar:[1,10],min:13,minconn:11,mingw:10,minimum:4,minor:[1,10],mintimeloggingcursor:10,minu:10,minut:[9,13],miser:13,mismatch:8,miss:[6,8,10],mix:13,mod_wsgi:[6,10],mode:[0,1,2,4,6,10,13],model:[4,13],modifi:[0,2,5],modul:[0,1,2,3,4,5,7,8],modwsgi:6,mogrif:10,mogrifi:[0,2,5,10,13],monitor:4,month:9,most:[2,7,8,13],mostli:[2,7,9,13],move:[2,10,13],mscv:10,msvc:10,much:[0,10],multi:7,multipl:[2,10],multiprocess:[6,10,13],multithread:[0,2,10],must:[0,1,2,4,6,9,13],mutex:10,mutual:9,mvcc:[0,1,2,3,4,5,6,7,8,9,10,11,12,13],mxdate:4,mxdatearrai:4,mxdatetim:[4,10],mxdatetimearrai:4,mxinterv:4,mxintervalarrai:4,mxtime:4,mxtimearrai:4,my_uuid:5,myjson:5,mypic:13,mytabl:[0,5],n74:2,name:[0,1,2,3,4,5,6,9,10,13],namedtupl:2,namedtupleconnect:5,namedtuplecursor:10,namespac:[0,10],nan:10,nativ:10,nearest:13,neat:10,necessari:[4,10,13],necessarili:[4,9],need:[0,3,6,8,9,10,13],neg:[2,10,13],neither:1,nelson:10,nest:[5,6],network:2,never:[2,4,6,10,13],new_array_typ:[0,4,6,10],new_fil:[1,4],new_oid:[1,4],new_typ:[0,4,6],next:[1,2,10],nextset:2,non:[0,1,4,10,13],nonblock:0,none:[0,1,2,4,5,6,9,10,11,13],nonetheless:0,nonzero:1,nor:[1,13],normal:[6,10,13],note:[0,1,2,3,4,5,6,7,8,9],noth:[1,2,4],notic:[1,10],notifi:[0,1,10],notsupportederror:[1,2,9],now:[1,2,10,13],nspname:0,nuanc:8,null_ok:2,num:[2,5,13],number:[1,2,4,6,7,8,9,10],numer:[2,6,9,10,13],numericoid:10,oberstein:10,obj:[4,5],observ:13,obtain:[0,2,10,13],obvious:10,occur:[3,9],off:[5,9,10],offer:[0,1,5,9,11,13],offici:[8,10],offset:[2,4,10,13],often:[4,13],oid:[0,1,2,4,6,10],old:[6,10],older:[1,4,6,10,13],onc:[4,8,10,13],onli:[0,1,2,4,5,6,8,9,10,13],onto:13,open:[1,4,6,10,13],openssl:10,oper:[0,1,2,5,8,9,10,11,13],operationalerror:[0,1,4,9,10],oppos:6,optim:[2,10],option:[0,1,2,4,6,8,10],order:[0,4,5,8,10,13],ordinari:13,origin:[5,10],other:[0,1,2,3,4,5,6,8,9,10,13],otherwis:[1,2,4,6,13],our:6,out:[0,2,5,7,8,9,10,13],output:[0,2,10],outsid:[1,2,13],over:[2,6],overcom:9,overflow:10,overhead:[2,6,13],overrid:[5,10],overview:[1,2,4],own:[6,10],owner:1,packag:[6,7],page:[7,8,13],pair:5,paramet:[0,1,2,4,6,7,9,10],paramstyl:9,parlanc:13,pars:[0,4,5,6,10,13],parse_float:5,parser:[6,10],part:[1,2,6],parti:0,particip:[0,1],particular:[9,13],pass:[0,1,2,4,5,6,7,9,10,11,12],password:9,patch:[0,10],path:[6,8,10],payload:[0,1,10],pboolean:10,pend:1,peopl:10,pep:[0,4,10],per:[0,1,2,10,13],perform:[0,1,2,4,8,10,13],persist:13,peter:10,petrovich:10,pg_catalog:0,pg_config:[6,8,10],pg_namespac:0,pg_prepared_xact:1,pg_sleep:0,pg_type:[0,2,4],pgbouncer:1,pgcode:[3,9,10],pgerror:[9,10],pgpool:10,pgsql:[10,13],phase:[1,4,7,10],phenomena:1,pickl:10,picklabl:10,pictur:13,pid:[0,1,10],pip:[8,10],piro:10,place:[5,8,10],placehold:[2,6,13],plai:10,plain:[1,10],platform:[8,10],pleas:[0,8,10,13],plpgsql:13,plu:[4,9,10],plug:10,plugin:10,png:13,point:[0,1,2,4,10,13],point_oid:0,poll:[0,1],poll_error:4,poll_ok:[0,1,4],poll_read:[0,4],poll_writ:[0,4],pollut:0,pool:[0,6,7,10],poorli:10,pop:0,popul:1,popular:7,port:[8,9,10],pose:6,posit:[2,4,6,10,13],possibl:[0,1,2,4,5,6,8,10,13],postgr:[2,9,13],postgrespollingstatustyp:4,postgresql:[0,1,2],potenti:[1,10],pprint:1,pq_complete_error:10,pqbackendpid:1,pqcancel:1,pqconnectstart:0,pqfreemem:10,pqfsize:2,pqgetlength:2,pqgetresult:10,pqparameterstatu:1,pqprotocolvers:1,pqserververs:1,pqtransactionstatu:1,pre:[8,10],precis:[2,10,13],prefer:13,prefix:10,prepar:[0,1,2,4,10,13],presenc:0,present:9,previou:[0,1,2,4,5,6,13],previous:[0,1,2,4,9,13],primari:[1,13],print:[0,2,8,9,13],printabl:4,prior:1,probabl:[0,2,4,6],problem:[1,4],proce:[0,1],procedur:[2,10],process:[0,1,2,6,7,9,10],processor:10,procnam:2,produc:[0,2,3,10,13],program:[0,1,6,7,8,9,10,13],programm:[0,9],programmingerror:[1,2,4,9,10,13],progress:[1,4],project:[0,10],propag:10,proper:[0,9,10,13],properli:10,properti:[1,10,13],proport:6,proportion:13,propos:[0,13],protocol:[0,1],protocol_vers:[1,10],provid:[0,1,2,4,5,6,9,10,13],provok:10,psql:0,psycogreen:0,psycopg1:10,psycopg2:[0,1,2],psycopg2_test:8,psycopg2_testdb:8,psycopg2_testdb_host:8,psycopg2_testdb_port:8,psycopg2_testdb_us:8,psycopg:[0,1,2,4],psycopg_debug:[8,10],psycopg_display_s:[2,10],pthread:10,publish:13,pumukel:10,pure:[8,11],push:1,put:[10,11],putconn:11,py27:8,py2ex:10,pydat:4,pydatearrai:4,pydatetim:4,pydatetimearrai:4,pyformat:9,pyinterv:4,pyintervalarrai:4,pyobject_head:10,pypi:8,python_egg_cach:6,pytim:4,pytimearrai:4,qstring:10,qualifi:13,qualiti:8,queri:[0,1,2,4,5,6,7,9,10],querycancelederror:[1,4,9,10],quit:10,quot:[1,2,4,10,13],quotedstr:[4,10],rais:[0,1,2,4,6,9,10,13],random:10,rant:10,rather:[1,2,3,4,9,10],raudsepp:10,raw:9,read:[0,1,2,4,5,6,8,10,13],readabl:[0,2],readi:[0,1,4,11],readlin:[2,13],readonli:1,real:0,realdictconnect:10,realdictcursor:10,realdictrow:10,realli:10,reason:[1,13],rec:5,receiv:[0,1,4,6,10,13],recent:[8,10],recept:[0,10],recip:13,recogn:[3,13],record:[2,5,10,13],recov:[1,6],recoveri:[1,13],recurs:4,red:10,redefin:2,refcount:10,refcursor:13,refer:[0,2,8,10,13],referenc:10,reffunc:13,refus:10,regist:[0,2,4,5,6,13],register_adapt:[0,4,5,13],register_composit:[5,10,13],register_default_json:[5,6],register_default_jsonb:5,register_hstor:[5,10],register_inet:5,register_json:[5,6],register_rang:5,register_tstz_w_sec:[10,13],register_typ:[0,2,4,6,10,13],register_uuid:[0,5],registr:[0,5],registri:10,regress:10,regular:[0,1,2,4,5,8,9,13],reilli:[4,13],rel:2,relat:[1,2,4,9,10,13],releas:[0,1,3,5,6,7,8],relev:[4,6],reli:[0,1,4,13],reliabl:[2,13],remain:[1,2,4,13],rememb:[6,10,13],remov:[4,10],renam:10,reorgan:10,repeat:[1,4,10],replac:[2,4],report:[1,4,6,8,10],repositori:10,repr:[10,13],repres:[1,2,3,4,9,13],represent:[0,2,4,5,6,10,13],request:[1,9,10],requir:[0,1,2,4,5,6,8,9,10,13],resembl:13,reserv:2,reset:[1,10],resourc:[0,1,6,13],resp:4,respect:[8,9,10],respons:[0,10,13],restor:[1,10],result:[0,1,2,4,5,6,7,9,10,13],retain:2,retri:4,retriev:[0,2,5,13],reveal:10,revert:1,revis:[1,10,13],rework:10,right:[8,10],robust:[10,13],roll:[1,13],rollback:[0,1,2,4,6,9,10,13],rome:13,ronan:10,round:[10,13],roundtrip:[2,10,13],rous:10,row:[2,5,9,10],row_factori:10,rowcount:[2,10],rowid:[4,9],rowidarrai:4,rownumb:[2,10],rule:[2,5],run:[0,1,2,4,6],runtim:[4,6,8],ryan:10,safe:[0,1,2,4,6,10,13],safer:10,safeti:[1,2,6,7,9],sai:6,same:[0,1,2,4,5,6,7,9,10,13],satisfi:8,save:6,savepoint:6,scale:[2,10],schedul:0,scope:[0,4,13],script:[0,1,10,13],scroll:[1,2,10,13],scrollabl:[1,2,10,13],search:[5,7],second:[0,4,6,9,10,13],secret:9,section:9,secur:7,see:[0,1,2,4,5,6,9,10,13],seek:4,seem:[6,10],seen:2,segfault:10,select:[0,1,2,4,5,6,9,10,13],self:[0,5,13],semant:0,send:[0,4,6,10,13],sent:[0,1,2,4,10,13],sep:2,separ:[0,2,10,13],seq_of_paramet:2,sequenc:[1,2,6,10,13],seri:10,serial:[1,4,10,13],serializ:[1,4],serv:13,server:[0,1,2,3,4,5,6,7,8,9,10],server_encod:1,server_vers:[1,10,13],session:[0,1,2,4,6,9,10,13],session_author:1,set:[0,1,2,4,5,6,8,9,10,12,13],set_client_encod:[0,1,10,13],set_isolation_level:[0,1,4,10,13],set_sess:[0,1,10,13],set_wait_callback:[0,1],setinputs:2,setoutputs:2,setup:[8,10],sever:[0,1,5,6,7,9,10,13],share:[0,1,6,7,9,10,13],shell:0,shift_jis_2004:10,ship:8,should:[0,1,2,3,4,6,8,9,10,13],shouldn:[1,13],show:[1,13],shown:4,side:[1,2,5,7,10],sign:10,signatur:4,signific:2,silent:10,similar:[0,2,5,9,10],similarli:0,simpl:[0,1,4,9,10,11,13],simplejson:5,simpli:0,sinc:[0,1,4,9,13],singl:[0,1,2,4,6,9,13],singleton:9,site:13,situat:10,size:[2,4,6,10],skip:6,sleep:0,slightli:10,slow:[6,10],small:[6,10],smallint:13,smit:10,snapshot:4,snow:10,socket:[0,8,9,10],softwar:10,solari:10,solid:10,solut:10,solv:[6,10],some:[0,1,3,4,5,8,10,13],some_t:13,someth:[0,5,13],sometim:[8,10,13],somewher:5,soon:[1,6,13],sourc:[0,1,7],special:[2,4,9,10,13],specif:[0,1,2,3,4,7,9,10,13],specifi:[0,1,2,4,8,9,10,13],spell:0,spew:10,split:10,spuriou:10,sql1:13,sql2:13,sql_debug:0,sql_in:[4,10],sqlalchemi:0,sqlstate:[3,10],ssl:6,sslmode:[9,10],stabl:[4,10],stamp:9,stand:10,standard:[0,1,2,3,4,5,8,9,13],standard_conforming_str:[1,4,10],standarderror:9,starbuck:8,start:[0,1,4,6,10,13],state:[0,2,4,9,10,13],statement:[1,2,6,9,10],statu:1,status_begin:4,status_in_transact:[1,4],status_prepar:4,status_readi:[1,4],statusmessag:2,stderr:8,stdin:2,stdout:2,steal:13,steve:10,still:[0,1,3,5,7],stop:10,store:[2,4,5,13],stori:13,str:[0,1,4,6,10,13],straight:8,strategi:0,stream:[8,13],streamlin:8,stress:13,stricter:4,strictest:4,string:[0,1,2,4,5,6,9,10],string_typ:4,stringarrai:4,stringio:2,structur:[2,5,13],stuff:10,style:[0,9,13],sub:[0,8,10],subclass:[0,1,3,4],subject:3,sublcass:0,submit:2,subsequ:13,subtl:13,succe:1,sudo:8,suggest:[6,10],suit:5,suitabl:[0,1,13],superclass:10,supps:6,sure:[6,8,10,13],swallow:10,symbol:[1,3,6,9,10],sync:[9,10],synchron:0,system:[0,1,2,4,6,7,8,10,13],systemerror:10,tab:2,tabl:[1,2,3,4,5,7,9,10,13],take:[0,4,6,8,9,10],taken:[1,2,13],target:[2,13],task:[4,8],tbar:2,tcp:[6,10],team:10,tell:[2,4],termin:[1,13],terribl:13,test:[0,2,3,5],text:[5,10,13],textiobas:[2,10],textual:[2,3],tfoo:2,than:[0,1,2,3,4,5,9,10,13],thank:[7,10],thei:[0,2,4,5,6,8,10,13],them:[0,1,2,4,5,6,8,9,10,13],themselv:10,therebi:0,therefor:0,thi:[0,1,2,3,4,5,6,9,10,11,12,13],thing:8,think:6,third:0,those:4,though:[1,5,13],thread:[0,1,2,6,7,9,10],threadsafeti:9,three:[3,6,10,13],through:[0,2,4,9,10],thu:[0,3,9,13],tick:9,ticket:10,tight:6,time:[0,1,2,4],timearrai:4,timedelta:13,timefrommx:4,timefrompi:4,timefromtick:[9,10],timeout:[0,4,10],timestamp:[2,9,10,13],timestampfrommx:4,timestampfrompi:4,timestampfromtick:[9,10],timestamptz:13,timetz:[10,13],timezon:[1,10,13],tinyerp:10,tobia:10,togeth:[0,1,9],too:[4,6,10,13],tool:[9,10,13],total:[2,10],tpc:1,tpc_:1,tpc_begin:[1,13],tpc_commit:[1,4,13],tpc_prepar:[1,13],tpc_recov:[1,10,13],tpc_rollback:[1,4,13],transact:[0,1,2],transaction_status_act:4,transaction_status_idl:4,transaction_status_inerror:4,transaction_status_intran:4,transaction_status_unknown:4,transactionrollbackerror:[4,9,10],transfer:[0,6,13],transform:5,translat:13,transpar:0,trap:[4,9,10],tree:[8,10],trick:6,trip:10,tripl:1,truncat:[4,9,10],tupl:[1,2,4,5,6,10],tuple_factori:10,turn:[9,10],twitter:8,two:[0,1,2,3,4,6,7,9,10,12],typarrai:4,type_cod:[2,9],typecast:[0,2,4,5,6,10,13],typenam:0,typic:[5,13],typnam:[0,4],typnamespac:0,tzinfo:[2,7,10],tzinfo_factori:[2,12],u20ac:13,ubuntu:8,unabl:6,unauthor:13,unbound:10,uncheck:10,unclean:1,uncommit:[1,4],undefin:[1,6],undefined_t:3,under:[9,10],underli:1,undesir:[1,13],unescap:13,unexpect:[8,9],unfortun:13,unicod:[1,2,4,5,6,7,10],unicodearrai:[4,6,13],uniformli:13,uniqu:5,unix:[8,9],unknown:[4,13],unless:[0,1,2],unlik:13,unlink:4,unlock:10,unpack:[1,8],unpackag:8,unpars:[6,13],unsaf:[1,10],unstabl:8,until:[0,1,4,5,6,13],untouch:2,untrust:[1,13],untyp:9,unus:[1,2,6],unwant:5,updat:[2,6,7,10],upgrad:6,upon:[0,4,10],uppercas:2,url:10,usabl:[1,13],usag:[4,7,8,10],user:[0,2,5,6,8,9,10,13],usr:8,usual:[0,2,3,4,6,8,13],utc:[10,13],utf8:13,utf:[6,10],uuid_adapt:0,vacuum:[1,4,13],valid:[1,4,9,13],valu:[0,1,2,3,4,5,6,7,9,10],valueerror:10,varchar:13,variabl:[0,2,6,8,9,10,13],variant:[9,10],variou:10,varrazzo:10,verbatim:9,veri:[6,8,9],verifi:13,version:[0,1,2,3,4,5,6,8,9,10,13],via:[0,2,10,13],viabl:0,view:[0,1,4],virtualenv:8,visibl:2,vivisect:10,wai:[0,2,5,6,10,13],wait:[0,1,4],wait_select:0,want:[0,1,4,5,8,10,13],warn:[9,10],wasn:2,wast:[0,8],weakli:10,web:13,week:8,well:[5,10,13],went:2,were:[1,4,9,10,13],what:[1,2,3,6,7],whatev:8,when:[0,1,2,4,5,6,8,9,10,13],whenc:4,whenev:[0,1,2],where:[0,2,4,5,6,10,13],wherea:13,which:[0,1,2,3,4,6,8,9,10,13],whole:[6,10,13],whose:[0,4],why:6,wide:13,widespread:13,win32:10,window:[8,10],winsock2:10,wish:0,wither:10,withhold:[1,2,13],within:[1,3,4],without:[0,1,8,10,13],woodcraft:10,work:[0,4,6,10,13],workaround:5,worst:8,would:[0,2,4,13],wouldn:1,wrap:[0,2,4,9,13],wrapped_object:4,wrapper:[0,4,7,8,13],writabl:[0,2,6],write:[0,1,2,4,6,8,10,13],written:[4,5,10,13],wrong:[6,9,10,13],wrongli:10,wsgipythonegg:6,x00:4,x08:4,x0f:4,x82:13,x86_64:10,xa0:13,xa4:13,xa8:13,xac:13,xb2:13,xb9:13,xc3:13,xe0:13,xe2:13,xe8:13,xec:13,xf2:13,xf9:13,xid:[1,13],year:[6,9],yet:[2,4,8],you:[0,1,2,4,5,6,7],your:[2,5,6,8,10,13],zero:9,zip:5,zone:2,zope2:10,zope:10,zpsycopgda:10,zsql:10},titles:["More advanced topics","The <code class=\"docutils literal\"><span class=\"pre\">connection</span></code> class","The <code class=\"docutils literal\"><span class=\"pre\">cursor</span></code> class","<code class=\"docutils literal\"><span class=\"pre\">psycopg2.errorcodes</span></code> &#8211; Error codes defined by PostgreSQL","<code class=\"docutils literal\"><span class=\"pre\">psycopg2.extensions</span></code> &#8211; Extensions to the DB API","<code class=\"docutils literal\"><span class=\"pre\">psycopg2.extras</span></code> &#8211; Miscellaneous goodies for Psycopg 2","Frequently Asked Questions","Psycopg &#8211; PostgreSQL database adapter for Python","Introduction","The <code class=\"docutils literal\"><span class=\"pre\">psycopg2</span></code> module content","Release notes","<code class=\"docutils literal\"><span class=\"pre\">psycopg2.pool</span></code> &#8211; Connections pooling","<code class=\"docutils literal\"><span class=\"pre\">psycopg2.tz</span></code> &#8211;  <code class=\"docutils literal\"><span class=\"pre\">tzinfo</span></code> implementations for Psycopg 2","Basic module usage"],titleterms:{"class":[1,2],"function":4,"new":[0,10],access:13,adapt:[0,4,5,7,13],addit:[4,5],advanc:0,api:[1,2,4,9],ask:6,asynchron:0,basic:13,best:6,beta:10,binari:13,build:8,cast:[0,4,5],code:3,commit:13,compil:6,composit:5,connect:[0,1,4,5,11],constant:[4,13],constructor:9,content:9,control:13,convers:6,copi:13,coroutin:[0,5],creat:8,current:10,cursor:[0,2,5,13],data:5,databas:[4,7],date:13,debug:8,defin:3,deploi:6,dictionari:5,error:3,errorcod:3,except:[4,9],extens:[1,2,4,9],extra:5,factori:0,fraction:5,frequent:6,from:[8,13],goodi:5,handl:[6,13],have:8,hstore:5,implement:12,inet:5,infinit:13,instal:8,introduct:8,isol:4,json:5,larg:13,level:4,librari:0,like:5,list:13,log:5,manag:8,miscellan:5,modul:[9,13],more:0,namedtupl:5,note:10,notif:0,number:13,object:[0,4,9,13],packag:8,paramet:13,pass:13,phase:13,poll:4,pool:11,postgresql:[3,7,13],practic:6,problem:[6,8,13],process:13,protocol:[4,13],psycopg2:[3,4,5,6,9,11,12],psycopg:[5,7,10,12],python:[0,7,8,13],queri:13,question:6,rang:5,real:5,releas:10,run:8,safeti:13,server:13,side:13,sourc:8,sql:[0,4,13],statement:13,statu:4,still:8,string:13,subclass:5,suit:8,support:[0,5,13],syntax:0,test:8,thread:13,time:[5,13],topic:0,transact:[4,6,13],tupl:13,two:13,type:[0,4,5,6,9,13],tzinfo:12,unicod:13,usag:13,uuid:5,valu:13,what:10,you:8,zone:[5,13]}})