Search.setIndex({docnames:["dbapi","index","quickstart","release_notes","types"],envversion:{"sphinx.domains.c":2,"sphinx.domains.changeset":1,"sphinx.domains.citation":1,"sphinx.domains.cpp":5,"sphinx.domains.index":1,"sphinx.domains.javascript":2,"sphinx.domains.math":2,"sphinx.domains.python":3,"sphinx.domains.rst":2,"sphinx.domains.std":2,sphinx:56},filenames:["dbapi.rst","index.rst","quickstart.rst","release_notes.rst","types.rst"],objects:{"":[[0,0,0,"-","pg8000"]],"pg8000.Connection":[[0,1,1,"","DataError"],[0,1,1,"","DatabaseError"],[0,1,1,"","Error"],[0,1,1,"","IntegrityError"],[0,1,1,"","InterfaceError"],[0,1,1,"","InternalError"],[0,1,1,"","NotSupportedError"],[0,1,1,"","OperationalError"],[0,1,1,"","ProgrammingError"],[0,1,1,"","Warning"],[0,2,1,"","autocommit"],[0,5,1,"","close"],[0,5,1,"","commit"],[0,5,1,"","cursor"],[0,2,1,"","notifies"],[0,2,1,"","notifies_lock"],[0,5,1,"","rollback"],[0,5,1,"","tpc_begin"],[0,5,1,"","tpc_commit"],[0,5,1,"","tpc_prepare"],[0,5,1,"","tpc_recover"],[0,5,1,"","tpc_rollback"],[0,5,1,"","xid"]],"pg8000.Cursor":[[0,2,1,"","arraysize"],[0,5,1,"","close"],[0,2,1,"","connection"],[0,2,1,"","description"],[0,5,1,"","execute"],[0,5,1,"","executemany"],[0,5,1,"","fetchall"],[0,5,1,"","fetchmany"],[0,5,1,"","fetchone"],[0,2,1,"","rowcount"],[0,5,1,"","setinputsizes"],[0,5,1,"","setoutputsize"]],"pg8000.Interval":[[0,2,1,"","days"],[0,2,1,"","microseconds"],[0,2,1,"","months"]],pg8000:[[0,1,1,"","ArrayContentEmptyError"],[0,1,1,"","ArrayContentNotHomogenousError"],[0,1,1,"","ArrayContentNotSupportedError"],[0,1,1,"","ArrayDimensionsNotConsistentError"],[0,2,1,"","BINARY"],[0,3,1,"","Binary"],[0,4,1,"","Bytea"],[0,4,1,"","Connection"],[0,4,1,"","Cursor"],[0,6,1,"","DATETIME"],[0,1,1,"","DataError"],[0,1,1,"","DatabaseError"],[0,3,1,"","Date"],[0,3,1,"","DateFromTicks"],[0,1,1,"","Error"],[0,1,1,"","IntegrityError"],[0,1,1,"","InterfaceError"],[0,1,1,"","InternalError"],[0,4,1,"","Interval"],[0,6,1,"","NUMBER"],[0,1,1,"","NotSupportedError"],[0,1,1,"","OperationalError"],[0,1,1,"","ProgrammingError"],[0,6,1,"","ROWID"],[0,6,1,"","STRING"],[0,3,1,"","Time"],[0,3,1,"","TimeFromTicks"],[0,3,1,"","Timestamp"],[0,3,1,"","TimestampFromTicks"],[0,1,1,"","Warning"],[0,6,1,"","__version__"],[0,6,1,"","apilevel"],[0,3,1,"","connect"],[0,6,1,"","paramstyle"],[0,6,1,"","threadsafety"]]},objnames:{"0":["py","module","Python module"],"1":["py","exception","Python exception"],"2":["py","attribute","Python attribute"],"3":["py","function","Python function"],"4":["py","class","Python class"],"5":["py","method","Python method"],"6":["py","data","Python data"]},objtypes:{"0":"py:module","1":"py:exception","2":"py:attribute","3":"py:function","4":"py:class","5":"py:method","6":"py:data"},terms:{"0":[0,1,2],"00":1,"003":2,"01":[1,2],"02":1,"03":1,"04":1,"05":1,"06":[1,2],"07":[0,1],"08":1,"09":1,"1":[0,1,2],"10":1,"100":3,"11":[0,1,2],"12":[1,2],"12271":2,"13":1,"14":1,"15":1,"16":[1,2],"17":1,"18":1,"1980":2,"2":[0,1,2,4],"20":1,"2007":1,"2008":1,"2009":1,"2010":1,"2013":[1,2],"2014":1,"2015":1,"2016":1,"22":1,"26":[1,2],"27":[1,2],"28":0,"29":0,"3":[0,1,2,4],"30":[0,1],"31":0,"32":0,"4":[1,2],"44":3,"4beta2":3,"5":1,"500":2,"5432":0,"57960":2,"6":1,"64":0,"7":[0,1,2],"8":[0,1],"8000th":1,"9":[0,1],"boolean":[0,3],"byte":[0,3,4],"case":[0,3,4],"class":[1,3],"default":[0,2,3],"do":[0,3],"enum":[3,4],"float":[3,4],"function":[1,2,3],"import":[0,2,3],"int":[3,4],"long":[3,4],"new":[0,3],"null":[3,4],"public":3,"return":[0,2,3,4],"true":[0,2,3],"try":3,"while":[0,3],A:[0,2,3],As:0,At:[0,3],By:2,For:[0,2,3],INTO:2,If:[0,1,3,4],In:[0,3],It:[0,1,2,3],No:0,On:0,One:0,TO:[0,2],That:3,The:[0,1,3,4],There:[0,1,3],These:3,To:2,__iter__:3,__next__:3,__str__:0,__version__:0,_send:3,abl:3,about:[1,3],abov:0,access:[0,3],accord:3,accuraci:3,activ:0,actual:3,ad:3,add:[2,3],address:3,affect:[0,3],after:[0,3],again:3,against:0,alex:3,alia:3,all:[0,1,2,3],allow:3,alreadi:3,also:[1,3],although:[2,3],alwai:3,amazon:3,an:[0,1,2,3,4],anal:3,ani:[0,1,3],anoth:2,api:[0,1,2,3],apilevel:[0,3],apollo:2,applic:0,approach:3,appropri:3,ar:[0,1,3],arg:0,argument:0,arrai:[0,3],arrang:3,array_prepend:2,arraycontentemptyerror:0,arraycontentnothomogenouserror:0,arraycontentnotsupportederror:0,arraydimensionsnotconsistenterror:0,arrays:0,ascii:[0,3],ask:[2,3],associ:0,assum:[0,3],attempt:[0,3],attribut:[0,3],authent:[0,3],auto:3,autocommit:[0,2,3],avail:[0,3],awai:3,back:[0,3],backend:[0,3],backward:3,band:3,base:[0,3],basic:3,becaus:3,been:[0,2,3],befor:[0,3],begin:0,being:[0,3],belief:1,ben:3,benjamin:3,best:2,better:3,between:[0,4],binari:[0,3],bind:[0,3],bishop:3,bit:[0,3],bob:3,book:2,bool:[3,4],both:3,bottom:3,bound:0,brace:3,branch:3,branch_qualifi:0,bsd:1,buffer:[0,3],bug:[0,1,3],built:0,bytea:[0,3,4],bytearrai:3,bytes_or_buff:0,c8609701b348b1812c418e2c7:3,c:2,cach:3,call:[0,3],callback:3,can:[0,2,3],cannot:0,capit:3,cast:2,caus:3,cave:2,chanc:3,chang:[0,2,3],charact:[0,2],check:3,choos:0,chosen:2,christian:3,circleci:3,cirski:3,claus:1,clean:0,client:[0,2,3],client_encod:[2,3],close:[0,2,3],code:[0,3],codebas:3,collect:[0,3],column:0,com:[1,3],come:1,command:[0,2,3],commandcomplet:3,commit:[0,2,3],common:0,commun:[2,3],compat:[1,3],compil:[1,3],complet:3,complianc:3,conf:2,configur:3,conform:3,conn:[2,3],connect:[0,2,3],connectionclosederror:3,constant:0,constrain:0,construct:0,constuct:0,consum:3,contain:0,content:[0,3],continu:3,contribut:1,control:0,convers:3,convert:[0,3],cope:3,copi:[0,3],copy_from:3,copy_to:3,correctli:3,could:3,count:[0,3],cpython:2,creat:[0,2,3],cur:2,current:[0,3],cursor:[0,2,3],cursorwrapp:3,d:[1,3],dai:0,data:[0,3],databas:[0,1,2,3],databaseerror:[0,3],dataerror:0,date:[0,2,3,4],datefromtick:0,datetim:[0,2,3,4],db:[0,1,2,3],dbapi:[0,3],de:[2,3,4],dead:2,deal:3,decim:[3,4],decimal_out:3,decod:[0,3],defin:[0,3],delet:3,depend:[0,3],deprec:3,dequ:3,deriv:0,describ:0,descript:[0,3],detail:3,determin:[0,3],develop:3,dict:[0,3],did:3,didn:3,differ:3,dimens:0,directli:3,display_s:0,distinct:1,distribut:[1,3],doc:3,document:3,doe:[1,3],doesn:[0,3,4],don:3,done:[0,3],doubl:3,driver:3,drop:3,due:[0,3],dump:2,dure:[0,3],e:0,each:[0,3],easier:3,eg:[0,2,3],egg:3,either:0,element:[0,3],empti:[0,3],emptyqueryrespons:3,encod:[0,2,3],encount:0,encrypt:0,end:[0,3],ender:2,engin:1,ensur:3,entir:1,entri:0,environ:3,epoch:0,error:[0,3],especi:3,euc:0,event:3,everi:3,everyth:3,exampl:[0,1,3],except:[1,3],execut:[0,2,3],executemani:[0,3],exhaust:3,exist:3,expect:0,explicitli:3,expos:0,extens:[0,3],extern:1,extract:2,facil:3,fail:[0,3],fall:3,fals:[0,2],faster:3,featur:1,fetch:0,fetchal:[0,2],fetchmani:[0,3],fetchon:[0,2],few:3,field:[0,3],file:[0,3],fileobj:3,find:3,first:[0,3],fit:0,fix:3,flexibl:3,float8:4,flush:3,follow:[0,2,3,4],fork:3,form:[0,3],format:[0,2,3],format_id:0,forum:1,from:[0,1,2,3,4],full:3,fulli:3,funkybob:3,furthermor:0,game:2,gavin:3,gaynor:3,gener:[1,3],getdefaultencod:0,github:[1,3],give:3,given:[0,3],global:[0,3],global_transaction_id:0,go:3,googl:[1,3],group:[1,3],guarante:0,ha:[0,2,3,4],hackgnar:3,had:[0,3],hadn:3,handl:[0,3,4],handler:[0,3],hashlib:3,have:[0,3,4],hear:1,held:0,henc:3,here:2,hofstaedtl:3,hold:[0,3],hopefulli:3,host:0,hostnam:0,hour:0,how:[3,4],howev:[0,3],http:[1,3],i:[0,3],id:[0,2],idea:1,identifi:0,ie:3,imagin:3,immedi:3,implement:[0,3],improv:3,includ:3,incompat:3,inconsist:0,increas:3,independ:0,index:1,individu:3,inet:[3,4],infin:[3,4],inform:[0,3],initi:3,input:3,insert:2,insid:3,inspect:0,instal:[1,3],instanc:[0,3],instead:[0,3],int2:3,int2vector:[3,4],int4:[3,4],int8:3,integ:0,integer_datetim:3,integr:[0,3],integrityerror:0,intend:0,interact:1,interfac:[0,1,3],interfaceerror:[0,3],intern:[0,2,3],internal_s:0,internalerror:0,interv:[0,2,3,4],invalid:0,ip:0,ipaddress:4,ippolito:3,ipv4address:4,ipv4network:4,ipv6address:4,ipv6network:4,ipv:3,isn:3,issu:[0,1,3],item:0,its:3,itself:0,jdkx:3,jp:0,json:[2,3,4],jsonb:[3,4],just:[1,3],jython:2,kei:[1,3],kwarg:0,lack:3,languag:1,larg:[0,3],last:0,lazi:3,leak:3,leap:0,least:0,leav:3,lengthen:0,let:3,letter:3,level:0,libari:3,libpq:1,librari:[1,3],licenc:3,licens:1,like:[0,3],limit:3,line:3,list:[0,3,4],listen:0,localhost:0,locat:3,lock:[0,3],log:1,longer:3,look:3,lookup:3,loop:3,loosevers:3,lost:3,lot:3,love:1,machin:3,mai:[0,3],main:3,maintain:3,make:[0,3],makefil:3,manag:0,mani:1,map:[0,1,3],mariano:3,mark:0,marker:0,max:[3,4],md5:3,mean:[0,3],meaning:3,measur:0,memori:3,messag:[1,3],method:[0,3],mfenniak:[1,3],microsecond:0,millennium:2,min:[3,4],minut:0,miss:3,mode:3,modif:0,modifi:0,modul:[0,1,3],moment:3,month:[0,3,4],moran:3,more:[0,3],most:3,mostli:3,move:3,much:3,multi:0,multipl:3,must:[0,3],my_db:0,my_nam:0,my_password:0,n:3,name:[0,1,3],namespac:3,necessari:0,necessarili:0,need:[0,3],network:3,never:[0,3],next:[0,3],non:3,none:[0,3,4],nonetheless:3,note:[0,1,4],noth:0,notic:3,notif:[0,3],notifi:[0,3],notifies_lock:[0,3],notsupportederror:0,now:[2,3],null_ok:0,num:0,number:[0,2,3],numer:[0,2,3,4],numeric_send:3,o:3,obj:3,object:[0,3],objet:0,occasion:0,occur:[0,3],off:[0,2,3],oid:[0,3],old:3,older:0,omit:0,one:[0,1,2,3],ones:3,onli:[0,3,4],onward:4,open:[0,3],oper:0,operationalerror:[0,3],option:[0,3],order:0,organ:1,origin:3,orm:3,os:3,other:[0,3],otherwis:[0,3],out:[0,3],output:3,outsid:[0,3],overflowerror:0,p:[2,3],packag:3,packet:3,page:1,param_set:0,paramat:3,paramet:[0,2,3,4],parameter_set:0,paramnam:0,paramstyl:[0,2,3],pars:3,part:0,particip:0,pass:3,password:[0,2,3],patch:3,path:0,pend:0,peopl:3,per:[2,3],perform:[0,2,3],permit:[0,3],pg8000:[0,2,3,4],pg8000_test:3,pg800:3,pg:[0,3],pgsql:0,pguser:3,phase:[0,3],physic:0,pid:0,pip:[2,3],plain:3,plan:3,point:[1,3],popul:0,popular:3,port:0,portal:3,portal_numb:3,posit:0,possibl:[2,3],post:1,postgr:[0,2,3],postgresql:[0,1,2,3,4],potenti:3,pre:3,precis:0,prefer:3,prepar:[0,2,3],preparedstat:3,previou:3,previous:[0,3],print:2,printf:0,prior:0,probabl:[1,3],problem:[0,3],process:0,produc:0,product:3,program:[0,1],programerexcept:3,programm:0,programmerexcept:3,programmingerror:[0,3],progress:3,proper:3,properli:3,properti:[1,2,3],protocol:3,provid:[0,3],pull:3,punctuat:3,pure:1,put:1,py3:3,py:3,pyformat:[0,3],pypi:2,python:[0,1,2,3,4],qmark:0,queri:[0,2,3],question:0,quick:1,quickstart:3,r:3,rad:3,rais:[0,3],rang:3,rather:[0,3],re:[1,3],read:[0,3],readabl:[0,3],ready_for_queri:3,reason:[2,3],receiv:[0,3,4],recogn:[3,4],recognit:3,recommend:3,record:3,recov:3,recoveri:0,redshift:3,reduc:3,refer:0,refus:0,regist:0,reingart:3,rel:3,relat:0,releas:1,reli:1,remain:0,rememb:[2,3],remov:3,render:3,repeat:3,replac:3,report:[1,3],repr:0,repres:[0,3],represent:3,request:[0,1,3],resourc:0,respons:3,result:[0,2,3,4],retriev:3,revert:3,rewrit:3,robust:3,roll:0,rollback:[0,2,3],row:[0,2,3],row_data:3,row_descript:3,rowcount:[0,3],rowid:0,run:[2,3],runtim:3,s:[0,1,2,3],safe:3,safeti:0,sai:3,same:[0,3],scale:[0,3],scenario:3,schweizer:3,search:1,second:0,see:3,seem:3,select:[0,2,3],send:[0,3],sent:[2,3],separ:3,sequenc:[0,3],serial:[2,3,4],server:[0,2,3],set:[0,2,3],setinputs:0,setoutputs:0,setuptool:3,share:[0,2],sherri:3,should:[0,3],show:[2,4],side:[0,3],sign:0,signific:3,significantli:3,similar:3,simpler:3,simplifi:3,sinc:0,singl:[0,3],six:3,size:[0,3],slice:3,slightli:[0,3],small:0,snow:2,so:[0,3],socket:[0,3],solv:3,some:[2,3],somewhat:1,sourc:3,speaker:2,spec:3,specif:[1,2],specifi:0,speed:3,speedup:3,sphinx:3,sql:[0,2,3,4],sql_ascii:3,sqlalchemi:3,ssl:[0,3],standard:0,start:[0,1,3],state:[0,3],statement:[0,2,3],statement_numb:3,statu:3,still:3,str:[0,3,4],straight:3,stream:0,strict:0,strin:3,string:[0,3,4],struct:3,stuart:3,style:[0,2],subclass:0,subsequ:[2,3],suggest:3,suitabl:0,sum:3,support:[0,2,3],sure:3,suspend:3,sy:0,sync:3,t:[0,3,4],tabl:[2,4],take:3,tarbal:3,tcp:0,temporari:2,term:1,test:3,text:[2,3,4],than:[0,3],thank:3,thei:0,them:[0,3],theoret:3,thi:[0,3,4],thing:3,think:3,thought:3,thread:[0,2,3],threadsafeti:[0,3],three:3,through:[0,3],thrown:3,tick:0,time:[0,3,4],time_in:3,timedelta:[2,3,4],timefromtick:0,timeout:[0,3],timestamp:[0,2,3,4],timestamp_send_float:3,timestampfromtick:0,timestamptz:3,timezon:4,titl:2,tmp:0,togeth:1,too:[0,3],tpc:[0,3],tpc_begin:0,tpc_commit:[0,3],tpc_prepar:0,tpc_recov:[0,3],tpc_rollback:0,trail:3,transact:[0,3],transfer:0,translat:3,transmiss:3,transmit:0,tree:0,truncat:0,tupl:[0,3],turn:[0,2,3],two:[0,3],type:[1,2,3],type_cod:0,typic:0,tz:3,tzinfo:[3,4],u:3,uft8:3,uid:3,unbundl:3,under:[0,1,3],underli:3,underscor:3,unexpect:[0,3],unfortun:3,unicod:[3,4],unit:3,unittest:3,unix:[0,3],unix_sock:0,unless:4,unnam:3,unpack:3,unpack_from:3,unsupport:3,until:[0,3],unus:3,up:[0,3],updat:[0,3],upon:0,us:[0,1,2,3,4],usag:3,use_cach:3,user:[0,1,2,3],usernam:[0,3],utc:[3,4],utf8:[0,2,3],utf:3,uuid:4,vacuum:2,val:2,valid:3,valu:[0,2,3],varchar:3,variabl:3,variat:3,variou:3,ve:3,versa:4,version:[0,1,2],via:[0,3],vice:4,w:4,wa:[0,3],wai:[2,3],warn:[0,3],wasn:3,we:[1,3],websit:3,welcom:1,were:3,weren:3,what:1,wheel:3,when:[0,2,3],whenev:3,where:[0,3],which:[0,3,4],whitespac:3,who:1,wire:3,within:[0,3],without:[3,4],wo:4,won:3,work:3,would:3,wouldn:3,wrap:3,writabl:0,write:[0,3],written:1,wrong:3,xid:[0,3,4],xml:[3,4],year:0,yet:0,you:[0,1,3],your:[0,1],zero:3,zone:4},titles:["Properties","pg8000","Quick Start","Release Notes","Type Mapping"],titleterms:{"0":3,"00":3,"01":3,"02":3,"03":3,"04":3,"05":3,"06":3,"07":3,"08":3,"09":3,"1":3,"10":3,"11":3,"12":3,"13":3,"14":3,"15":3,"16":3,"17":3,"18":3,"2":3,"20":3,"2007":3,"2008":3,"2009":3,"2010":3,"2013":3,"2014":3,"2015":3,"2016":3,"22":3,"26":3,"27":3,"3":3,"30":3,"4":3,"5":3,"6":3,"7":3,"8":3,"9":3,"class":0,"function":0,content:1,exampl:2,except:0,gener:0,indic:1,instal:2,interact:2,kei:2,map:4,note:3,pg8000:1,point:2,properti:0,quick:2,releas:3,specif:0,start:2,tabl:1,type:[0,4],version:3}})