Search.setIndex({docnames:["announce","community/index","contents/changelog","contents/examples","contents/general","contents/index","contents/install","contents/pg/adaptation","contents/pg/connection","contents/pg/db_types","contents/pg/db_wrapper","contents/pg/index","contents/pg/introduction","contents/pg/large_objects","contents/pg/module","contents/pg/notification","contents/pg/query","contents/pgdb/adaptation","contents/pgdb/connection","contents/pgdb/cursor","contents/pgdb/index","contents/pgdb/introduction","contents/pgdb/module","contents/pgdb/typecache","contents/pgdb/types","contents/postgres/advanced","contents/postgres/basic","contents/postgres/func","contents/postgres/index","contents/postgres/syscat","contents/tutorial","copyright","download/index","index"],envversion:53,filenames:["announce.rst","community/index.rst","contents/changelog.rst","contents/examples.rst","contents/general.rst","contents/index.rst","contents/install.rst","contents/pg/adaptation.rst","contents/pg/connection.rst","contents/pg/db_types.rst","contents/pg/db_wrapper.rst","contents/pg/index.rst","contents/pg/introduction.rst","contents/pg/large_objects.rst","contents/pg/module.rst","contents/pg/notification.rst","contents/pg/query.rst","contents/pgdb/adaptation.rst","contents/pgdb/connection.rst","contents/pgdb/cursor.rst","contents/pgdb/index.rst","contents/pgdb/introduction.rst","contents/pgdb/module.rst","contents/pgdb/typecache.rst","contents/pgdb/types.rst","contents/postgres/advanced.rst","contents/postgres/basic.rst","contents/postgres/func.rst","contents/postgres/index.rst","contents/postgres/syscat.rst","contents/tutorial.rst","copyright.rst","download/index.rst","index.rst"],objects:{"":{pg:[11,0,0,"-"],pgdb:[20,0,0,"-"]},"pg.Connection":{cancel:[8,3,1,""],close:[8,3,1,""],date_format:[8,3,1,""],db:[8,4,1,""],endcopy:[8,3,1,""],error:[8,4,1,""],fileno:[8,3,1,""],get_notice_receiver:[8,3,1,""],getline:[8,3,1,""],getlo:[8,3,1,""],getnotify:[8,3,1,""],host:[8,4,1,""],inserttable:[8,3,1,""],locreate:[8,3,1,""],loimport:[8,3,1,""],options:[8,4,1,""],parameter:[8,3,1,""],port:[8,4,1,""],protocol_version:[8,4,1,""],putline:[8,3,1,""],query:[8,3,1,""],reset:[8,3,1,""],server_version:[8,4,1,""],set_notice_receiver:[8,3,1,""],status:[8,4,1,""],transaction:[8,3,1,""],user:[8,4,1,""]},"pg.DB":{"delete":[10,3,1,""],abort:[10,3,1,""],adapter:[10,4,1,""],begin:[10,3,1,""],clear:[10,3,1,""],commit:[10,3,1,""],db:[10,4,1,""],dbname:[10,4,1,""],dbtypes:[10,4,1,""],decode_json:[10,3,1,""],encode_json:[10,3,1,""],end:[10,3,1,""],escape_bytea:[10,3,1,""],escape_identifier:[10,3,1,""],escape_literal:[10,3,1,""],escape_string:[10,3,1,""],get:[10,3,1,""],get_as_dict:[10,3,1,""],get_as_list:[10,3,1,""],get_attnames:[10,3,1,""],get_databases:[10,3,1,""],get_parameter:[10,3,1,""],get_relations:[10,3,1,""],get_tables:[10,3,1,""],has_table_privilege:[10,3,1,""],insert:[10,3,1,""],notification_handler:[10,2,1,""],pkey:[10,3,1,""],query:[10,3,1,""],query_formatted:[10,3,1,""],release:[10,3,1,""],rollback:[10,3,1,""],savepoint:[10,3,1,""],set_parameter:[10,3,1,""],start:[10,3,1,""],truncate:[10,3,1,""],unescape_bytea:[10,3,1,""],update:[10,3,1,""],upsert:[10,3,1,""],use_regtypes:[10,3,1,""]},"pg.DbTypes":{get_attnames:[9,3,1,""],get_typecast:[9,3,1,""],reset_typecast:[9,3,1,""],set_typecast:[9,3,1,""],typecast:[9,3,1,""]},"pg.LargeObject":{"export":[13,3,1,""],close:[13,3,1,""],error:[13,4,1,""],oid:[13,4,1,""],open:[13,3,1,""],pgcnx:[13,4,1,""],read:[13,3,1,""],seek:[13,3,1,""],size:[13,3,1,""],tell:[13,3,1,""],unlink:[13,3,1,""],write:[13,3,1,""]},"pg.Notice":{detail:[8,4,1,""],hint:[8,4,1,""],message:[8,4,1,""],pgcnx:[8,4,1,""],primary:[8,4,1,""],severity:[8,4,1,""]},"pg.NotificationHandler":{close:[15,3,1,""],listen:[15,3,1,""],notify:[15,3,1,""],unlisten:[15,3,1,""]},"pg.Query":{dictresult:[16,3,1,""],fieldname:[16,3,1,""],fieldnum:[16,3,1,""],getresult:[16,3,1,""],listfields:[16,3,1,""],namedresult:[16,3,1,""],ntuples:[16,3,1,""]},"pgdb.Connection":{close:[18,3,1,""],closed:[18,4,1,""],commit:[18,3,1,""],cursor:[18,3,1,""],cursor_type:[18,4,1,""],rollback:[18,3,1,""],type_cache:[18,4,1,""]},"pgdb.Cursor":{arraysize:[19,4,1,""],build_row_factory:[19,3,1,""],close:[19,3,1,""],colnames:[19,4,1,""],coltypes:[19,4,1,""],copy_from:[19,3,1,""],copy_to:[19,3,1,""],description:[19,4,1,""],execute:[19,3,1,""],executemany:[19,3,1,""],fetchall:[19,3,1,""],fetchmany:[19,3,1,""],fetchone:[19,3,1,""],row_factory:[19,3,1,""],rowcount:[19,4,1,""]},"pgdb.TypeCache":{get_fields:[23,3,1,""],get_typecast:[23,3,1,""],reset_typecast:[23,3,1,""],set_typecast:[23,3,1,""],typecast:[23,3,1,""]},pg:{Bytea:[14,1,1,""],Connection:[8,2,1,""],DB:[10,2,1,""],DbTypes:[9,2,1,""],HStore:[14,1,1,""],INV_READ:[14,5,1,""],INV_WRITE:[14,5,1,""],Json:[14,1,1,""],LargeObject:[13,2,1,""],Literal:[14,1,1,""],NotificationHandler:[15,2,1,""],Query:[16,2,1,""],SEEK_CUR:[14,5,1,""],SEEK_END:[14,5,1,""],SEEK_SET:[14,5,1,""],TRANS_ACTIVE:[14,5,1,""],TRANS_IDLE:[14,5,1,""],TRANS_INERROR:[14,5,1,""],TRANS_INTRANS:[14,5,1,""],TRANS_UNKNOWN:[14,5,1,""],__version__:[14,5,1,""],cast_array:[14,1,1,""],cast_record:[14,1,1,""],connect:[14,1,1,""],escape_bytea:[14,1,1,""],escape_string:[14,1,1,""],get_array:[14,1,1,""],get_bool:[14,1,1,""],get_bytea_escaped:[14,1,1,""],get_cast_hook:[14,1,1,""],get_datestyle:[14,1,1,""],get_decimal:[14,1,1,""],get_decimal_point:[14,1,1,""],get_defbase:[14,1,1,""],get_defhost:[14,1,1,""],get_defopt:[14,1,1,""],get_defpasswd:[14,1,1,""],get_defport:[14,1,1,""],get_defuser:[14,1,1,""],get_jsondecode:[14,1,1,""],get_namedresult:[14,1,1,""],get_typecast:[14,3,1,""],set_array:[14,1,1,""],set_bool:[14,1,1,""],set_bytea_escaped:[14,1,1,""],set_cast_hook:[14,1,1,""],set_datestyle:[14,1,1,""],set_decimal:[14,1,1,""],set_decimal_point:[14,1,1,""],set_defbase:[14,1,1,""],set_defhost:[14,1,1,""],set_defopt:[14,1,1,""],set_defpasswd:[14,1,1,""],set_defport:[14,1,1,""],set_defuser:[14,1,1,""],set_jsondecode:[14,1,1,""],set_namedresult:[14,1,1,""],set_typecast:[14,3,1,""],unescape_bytea:[14,1,1,""],version:[14,5,1,""]},pgdb:{Binary:[24,1,1,""],Connection:[18,2,1,""],Cursor:[19,2,1,""],DataError:[22,6,1,""],DatabaseError:[22,6,1,""],Date:[24,1,1,""],DateFromTicks:[24,1,1,""],Error:[22,6,1,""],Hstore:[24,1,1,""],IntegrityError:[22,6,1,""],InterfaceError:[22,6,1,""],Interval:[24,1,1,""],Json:[24,1,1,""],Literal:[24,1,1,""],NotSupportedError:[22,6,1,""],OperationalError:[22,6,1,""],ProgrammingError:[22,6,1,""],Time:[24,1,1,""],TimeFromTicks:[24,1,1,""],Timestamp:[24,1,1,""],TimestampFromTicks:[24,1,1,""],Type:[24,2,1,""],TypeCache:[23,2,1,""],Uuid:[24,1,1,""],Warning:[22,6,1,""],apilevel:[22,5,1,""],connect:[22,1,1,""],get_typecast:[22,3,1,""],paramstyle:[22,5,1,""],reset_typecast:[22,3,1,""],set_typecast:[22,3,1,""],threadsafety:[22,5,1,""]}},objnames:{"0":["py","module","Python module"],"1":["py","function","Python function"],"2":["py","class","Python class"],"3":["py","method","Python method"],"4":["py","attribute","Python attribute"],"5":["py","data","Python data"],"6":["py","exception","Python exception"]},objtypes:{"0":"py:module","1":"py:function","2":"py:class","3":"py:method","4":"py:attribute","5":"py:data","6":"py:exception"},terms:{"0x80000000":2,"24e":25,"583e":25,"64bit":0,"694e":25,"913e":25,"boolean":[2,9,10,11,23,24],"break":[2,7],"byte":[2,7,10,13,14,17,19,24],"case":[2,7,8,10,14,15,17,19,22,23,24,26],"catch":22,"char":[7,17,24],"class":[2,7,8,9,11,12,13,14,15,16,17,18,19,22,23,24,26,29,30,33],"default":[2,6,7,9,10,11,15,17,18,19,22,23,24,30],"export":[2,11,24],"final":[2,6,7,10,17,26,30],"float":[2,7,10,14,15,17,24],"function":[2,7,8,9,10,11,12,13,15,16,17,18,19,20,23,24,28,30],"import":[2,6,7,10,11,14,17,22,25,26,27,29,30],"int":[2,7,8,9,10,13,14,15,16,17,19,22,23,24,26,30],"long":[2,7,8,17,19,24],"new":[1,2,5,6,7,8,9,10,13,14,15,16,19,20,22,23,24,26,27,30,33],"null":[2,14,17,19,24],"public":[2,26,30],"return":[2,7,8,9,11,13,15,17,19,20,22,23,24,26,27,29,30],"switch":[2,4,22],"true":[2,6,7,10,14,17,18,19,24,30],"try":[6,7,17,18,26,27,30],"while":[2,7,10,17,22],AND:[7,17,26,29,31],Added:2,And:[26,29],BUT:31,But:[7,17,26],FOR:31,For:[2,6,7,9,14,17,19,22,23,24,25,27,29,30,32,33],INTO:[6,7,17,25,26,27],ITS:31,Las:25,NOT:[29,31],ONE:27,One:7,SUCH:31,THE:31,That:7,The:[1,2,3,4,6,7,12,13,14,16,17,21,22,24,26,27,28,29,30,32,33],Then:30,There:[0,3,7,10,26,33],These:[6,8,9,10,13,14,18,19,22,23],USE:31,Use:2,Used:24,Using:[7,17,30],With:[7,10,17,33],__doc__:2,__init__:[7,10,17],__pg_repr__:[7,17],__pg_str__:7,__str__:[7,17],__version__:[2,14],_asdict:19,_make:19,_pg:[2,6,32],_quot:2,abandon:11,abl:[2,13,14],abort:10,about:[2,6,7,8,9,10,13,14,16,17,19,23,24,29],abov:[6,9,10,14,26,31],absent:15,accept:2,access:[2,6,8,10,12,14,16,26,30],accomplish:17,accord:[8,9,23],accordingli:[7,17,24],account:[1,2,14],accur:2,achiev:[2,7,17,26],activ:[1,14],actual:[2,10,17,29],adam:2,adapt:[2,10,11,14,20],add:[1,2,6,7,10,14,17,22,29,30],add_em:27,added:[1,2,6,8,10],adding:[7,17],addit:[2,9,14,22,23,26,30],addition:24,adjac:14,adjust:10,advanc:[2,28,30],advis:31,affect:[2,8,13,14,19,22,26],affix:2,after:[1,2,7,10,26],again:[2,6,7,10,17,19,26,30],against:19,age:27,aggfnoid:29,aggreg:[2,28],ago:2,agreement:31,alet:2,algorithm:19,alias:26,all:[1,2,6,7,8,9,10,12,13,14,15,17,18,20,22,23,25,26,29,30,31,32,33],alloc:[8,14,22],allow:[2,8,10,13,14,16,17,22,26,33],alreadi:[2,6,7,9,10,13,14,22,23,25,26,27,29],also:[0,1,2,6,7,8,9,10,13,14,15,17,18,19,22,23,24,26,27,30,32,33],alter:[7,14],altern:19,although:10,altitud:25,alum:2,alwai:[2,7,8,9,10,14,15,17,18,19,22,23,24,29],ambigu:[10,17],amd64:32,amnam:29,amop:29,amopfamili:29,amopopr:29,amount:[2,10,30],andi:27,andr:[2,31,33],andrew:21,ani:[2,8,10,13,15,16,18,19,26,27,31],announc:32,anonym:2,anoth:[4,7,9,10,13,14,15,17,22,23,26,30],ansi:2,answer:[1,27],anyarrai:[2,22],anyon:31,anyth:[10,30],anywai:[2,10],api:[2,4,5,8,10,12,18,19,21,22,23,24,32],apilevel:22,appear:[10,31],appl:30,appli:[18,29],applic:[3,7,19,33],application_nam:[2,8],appropri:[2,6],arbitrari:[2,8],archiv:1,arci:[0,1,7,31,33],arg1:10,arg2:10,arg:[2,8,10,29],arg_dict:[10,15],argument:[2,7,8,9,10,14,15,16,17,19,22,23,27,30],aris:31,around:[17,26],arrai:[2,7,9,10,11,16,17,22,23,24,28],array_low:[7,17],arrays:20,assign:19,associ:[9,13,15,19,23],assort:2,assum:[7,10,11,17,25,27,29],asynchron:15,atom:10,attack:[7,14,17],attempt:[18,19],attisdrop:29,attnam:[2,9,29],attnum:29,attrelid:29,attribut:[2,9,11,15,20,22,23,24,25,28,30],atttypid:29,augment:2,author:31,authorit:[4,21],auto:18,autocommit:30,automat:[2,6,7,8,10,14,16,17,30],auxiliari:11,avail:[0,2,4,6,7,10,14,15,17,19,32,33],avoid:[6,10,17],awai:2,back:[2,7,10,17,20,30],backend:8,backslash:[2,10,14],backward:2,bad:[8,10,13,14,16,17],banana:30,bang:2,bar:[10,27],base:[2,9,10,14,15,19,22,23,24,25,28,31,33],basi:31,basic:[2,7,9,10,12,14,17,25,27,28,29,30],batch:30,bdfl:33,beamnet:2,becaus:[7,10,13,15,17],becom:[2,7,10,14,18,33],been:[0,2,4,6,7,8,9,10,11,15,17,18,19,21,26,28,30,31,32],befor:[2,7,10,13,19,27],begin:[2,11],beginn:4,behavior:[2,7,10,17,19],behind:7,being:[1,8,9,10,14,17,19,26],below:[2,6,8,10,24,26],berkelei:2,besid:[9,14],best:[19,33],beta:32,better:[2,7,17],between:[2,7,14,17,26,30],bigfoot:2,bigint:24,bill:[25,27],bin:2,binari:[2,10,11,19,24,29],binary_op:29,bind:[7,24],blank:2,block:[8,10],bob:14,bojnourdi:2,bond:17,bookkeep:29,bool:[2,7,10,11,15,17,19,24],boot:6,both:[0,2,4,7,15,17,19,30],bottom:3,bound:[2,7,9,17,19,23,24],bouska:2,box:[7,17],bpchar:[7,17],brace:[14,25],breakfast:25,brian:2,brit:2,broken:2,brows:1,browser:1,broytmann:3,bsd:33,buffer:[8,13,19],bug:2,build:[2,7,10,11,16,17,19,32],build_row_factori:19,builder:19,built:[0,2,7,8,17,22,26,33],bump:2,bunch:30,bytea:[2,7,11,17,24],bytes_l:24,cach:[2,8,11,14,17,20,22],cain:[0,1,31,33],calcul:[7,17],call:[2,4,6,7,8,9,10,13,14,15,17,18,20,22,23,30,33],callabl:[8,14,19],callback:[8,10,14,15],caller:[2,10,15],callproc:[2,20],can:[1,2,3,4,6,7,8,9,10,13,14,15,16,17,18,19,22,23,24,25,26,27,28,29,30,32,33],cancel:11,candi:27,cannot:[10,14,17,19],capabl:[22,24],capit:[25,30],care:[7,10],carefulli:17,carol:25,carri:[2,9,23],cascad:[10,27],cast:[2,7,9,10,14,17,22,23],cast_arrai:[2,11],cast_circl:[7,17],cast_hstor:2,cast_item:[7,17],cast_json:17,cast_record:[2,14],cast_tupl:[7,17],caster:2,catalog:[10,28],categori:[9,23],caus:[2,10,14,15,17,18],central:1,certain:[2,8,9,10,14,22,23,26],cfg:32,cgi:32,chain:19,chang:[0,1,2,5,7,8,10,13,14,17,18,19,22,26,29,30],changelog:[0,32],channel:15,chapter:[2,28,32],charact:[7,10,14,19],charli:2,cheap:8,check:[1,2,7,8,11,13,14,17,22,32],cherimaya:30,chifungfan:2,chimai:[31,33],choos:[12,21,30],chri:2,circl:[7,17],citi:[25,26],clair:27,clarifi:2,clash:2,class_nam:29,classic:[2,4,5,7,10,12,21,25,26,28,29,32],classifi:2,claus:[2,7,10,26],clean:[2,7],clean_emp:27,cleanli:2,cleanup:2,clear:[2,7,11,24,26,33],client:[2,4,6,11,15,19],client_encod:8,client_min_messag:8,close:[2,10,11,15,20,30],cls:14,clue:7,cnri:2,code:[1,2,3,6,8,9,14,17,18,19,22,23,24,31,32,33],col:10,collect:[0,2,3,7,17,32],colnam:[2,19],coltyp:[2,19],column:[2,7,10,16,17,20,24,26,27,29,30],com:2,combin:33,come:[2,6,8,14,15,22],comma:14,command:[1,2,6,7,11,14,15,17,19,22,26,27,29,30,32],comment:1,commerci:33,commit:[2,11,19,20,30],common:[14,17,22],commun:1,compar:[7,24,33],compat:[2,32],compil:2,complain:17,complement:2,complet:[8,10,22],complianc:2,compliant:[4,5,10,12,19,21,22,30,32,33],complic:26,compos:14,composit:[2,7,9,10,13,14,17,23,28],compromis:26,comput:[4,6],con1:14,con2:14,con:[8,14,17,19,22,24,30],concaten:7,concept:[4,7,17],concern:[2,13],condit:[10,19,26],configur:[2,7,10,32],conflict:11,conform:10,confus:[2,26],connect:[2,4,6,7,9,11,12,13,15,16,17,19,20,21,23,25,27,28,29,30],connection_handl:15,consequenti:31,consid:[2,7,22],consider:19,consist:[2,4],constant:[2,8,10,11,13,20],constraint:2,construct:[14,24],constructor:[2,17,20],consult:25,contain:[2,6,7,8,10,14,17,19,22,24],content:[10,13],context:[1,2,7,10,14,18,19],continu:[7,9,23],contribut:[2,31],contributor:1,control:[2,10,20,23],conveni:[2,4,10,12,26,30],convers:[2,7,11,17],convert:[2,7,10,14,16,17,19,22],copi:[2,6,8,19,30,31],copy_from:[2,19,30],copy_to:[2,19,30],copyright:33,correct:[2,16],correctli:[2,7,14,17],correspond:[2,7,9,10,14,17,26],could:[2,7,8,17,22,24],count:[7,17],cours:[7,17,26,30],cover:[1,2,12,21],crash:10,creat:[1,2,7,11,13,14,15,17,19,24,25,28,29,30,32],creation:[2,8,13],csua:2,csv:19,cur:[17,19,30],currenc:14,current:[1,2,6,7,9,10,11,13,14,17,19,22,23,26,30,33],current_timestamp:2,cursor:[2,13,17,20,23,24,30],cursor_typ:[18,19],custom:[2,7,11,17,18,19],customiz:2,cuteri:2,cvsweb:32,dai:[24,26],damag:31,danger:7,darci:[0,31,33],dat:14,data:[2,8,11,13,19,20,22,24,25,28,30,33],databas:[0,2,3,4,6,7,11,12,13,15,16,17,18,20,21,22,24,25,27,28,29,30,32,33],databaseerror:[2,19,22],dataerror:22,datastr:[10,14],date:[2,7,11,17,24,26],date_format:[11,14],datebas:15,datefromtick:24,datestyl:[8,10,14,26],datetim:[2,7,8,17,24],db_ride:10,dbapi:2,dbname:[10,14,26,30],dbtype:[7,10,11,14],dbutil:4,deactiv:[2,14],deal:14,dealloc:13,debug:2,decim:[2,7,11,17],decod:[2,11,17,19],decode_json:11,def:[7,10,17,19],defbas:14,defhost:14,defin:[8,10,13,14,16,22,24,25,28],definit:[8,13,14,16,32],defopt:14,defpasswd:14,defport:14,defus:14,degre:26,delet:[2,8,11,13,15,18,19,27,28,30],delim:[9,14,23],delimit:[9,14,19,23],deliv:19,demo:3,demonstr:[26,28],denot:15,depend:[2,4,10,19],deprec:[2,19],dept:27,derefer:13,dereferenc:13,deriv:[8,14],descend:[10,25],describ:[8,10,14,18,19,22,24],descript:[2,8,10,14,18,20,23,24],deseri:[10,14],design:14,destroi:10,desynchron:8,detail:[2,6,7,8,9,10,17,18,20,23,30,33],detect:24,determin:[7,11,19],devel:6,develop:[2,4,21,33],dice:[7,17],dict:[2,7,11,14,15,17,19,22,24,26,30],dictcursor:19,dictionari:[2,7,9,11,14,15,17,18,23,24,26,30],dictresult:[2,8,10,11,26,30],did:[7,8,10,19],didn:17,diff:1,differ:[7,10,14,15,17,19,22,26,30],dig:10,dildog:2,dimension:[2,14],direct:[2,6,8,31],directli:[1,2,6,7,8,10,14,15,17],directori:[0,6,32],disabl:[2,8,14],discard:[10,30],discern:30,disclaim:31,disconnect:22,discov:26,discuss:1,disk:[10,29],displai:16,display_s:19,distinct:26,distribut:[3,31,33],distutil:2,divis:22,dll:6,dml:19,dno_def_var:[6,14],dno_direct:[6,8],dno_larg:[6,8],dno_pqsocket:6,doc:32,docstr:2,document:[1,2,6,9,12,21,23,28,31,32],doe:[2,7,10,14,17,24,26,30],doesn:[2,6,8],doing:[8,26],don:[2,6,7,8,10,14,15,17,26],done:[6,7,17,19,26],doubl:[2,7,8],double_salari:27,download:6,dql:19,dream:27,driver:[2,4],drop:[2,26,27,29,30],druid:[2,31,33],dsn:22,due:[10,19,22],dump:[10,13,24,30],duplic:[13,14,26,30],durabl:10,dure:[8,10,14,22],durian:30,dust:2,dynam:[6,19,33],dyson:2,each:[8,10,16,19,24,26,29],earlier:[2,14],eas:[7,17],easi:[6,33],easier:[4,17],easili:[7,14,17,19,30,33],ebeon:2,ecp:[2,31,33],edu:2,eevolut:2,effect:[2,7,8,10,14,17,19],effici:19,eggfruit:30,ein:6,either:[3,7,10,12,15,21,25,30],element:[2,7,14,17,19,30],els:[10,12,21,30],emb:[8,13,33],embed:[7,10],emc:2,emp:27,emphas:17,employe:[8,10,14,25,27],empti:[2,8,11,19,26],enabl:[2,9,10,14],encapsul:[2,10],encod:[11,22,24],encode_json:10,end:[10,30],endcopi:11,enhanc:[2,31],enough:[7,17],ensur:8,enter:[1,26],enterpris:33,entri:[2,10,19],enumer:30,env:2,environ:[4,6,13,14],equal:[2,9,14,17,23,24],equival:[7,17,27],error:[2,7,8,10,13,14,16,17,18,19,20,26],escap:[2,7,8,11,17],escape_byt:10,escape_bytea:[10,11],escape_identifi:10,escape_liter:11,escape_str:[2,7,10,11],especi:[2,14],essenti:[9,19,23],establish:10,etc:[2,7,8,9,10,27],evalu:2,even:[2,7,10,14,17,19,30,31,33],event:[10,15,31],ever:8,everi:[2,8,10,14,17,27],everyth:10,exact:[7,13,17],exactli:[8,13,14,26],exampl:[5,6,7,8,10,12,14,17,22,24,28,30],except:[1,2,7,10,14,18,19,22,33],exclud:10,exe:32,execut:[2,6,7,11,17,20,24,26,30],executemani:[2,20,24,30],exist:[2,4,8,10,22,26],expand:2,expect:[17,19],expens:2,explain:[2,7,10,17,25,26,27,29],explan:[7,17],explicitli:[8,10,26],exploit:[7,17],expos:2,express:[10,26,27],extend:[19,22],extens:[2,4,6,7,9,14,30,32,33],extern:14,extra:[2,8,15,25],facto:33,factori:19,fail:[8,22],fallback:11,fals:[2,7,10,14,19,24],famili:28,far:[3,26],fast:[2,11],faster:[10,30],favicon:2,featur:[1,2,4,6,10,17,26,28,30,33],fed:14,fee:31,feet:25,fetch:[2,10,17,20,30],fetchal:[2,17,20,30],fetchmani:[20,30],fetchon:[17,20,30],few:[2,3,10,14],fewer:19,field:[2,8,9,10,11,14,19,23,24,25],fieldnam:11,fieldnum:11,fig:30,file:[0,2,3,6,11,14,19],fileno:[2,11],fill:26,filonenko:2,find:[2,4,6,7,16,17,25,26,32],fine:10,first:[2,5,6,7,8,10,13,17,18,25,26],fit:31,fix:[2,11],flag:[2,10,14,15],flavor:30,float4:[7,17],float8:[7,17,26],follow:[1,6,7,8,9,10,12,14,15,16,17,18,19,21,22,23,24,25,26,27,29,30,31],foo:[10,27],foo_bar_t:10,forbid:8,forc:2,fore:7,foreign:[10,22],forget:14,form:[4,7,8,10,14,19],format:[2,7,11,17,19,22,24,26,32],formerli:8,forward:[18,19],found:[2,16,19,22],four:14,fpic:6,fraction:15,framework:2,francisco:[25,26],frederick:2,free:2,freebsd:[0,32],freed:2,freeli:33,from:[2,4,7,11,13,14,16,17,18,19,21,22,24,25,26,27,28,29,30,32,33],fromkei:10,frontend:8,frozenset:2,fruit:30,ftp:32,fulfil:10,full:[2,6,8,10,23,30,33],fulli:2,func:[2,8,14],further:[1,2,31,33],furthermor:10,futur:[1,14,22],fuzzi:[7,17],garbag:2,garfield:14,gate:2,gener:[0,1,5,8,13,14,15,17,19,30],geometr:[7,17],gerhard:2,get:[1,2,7,9,11,17,18,19,20,23,26,30],get_arrai:14,get_as_dict:[2,7,10,30],get_as_list:[2,11],get_attnam:[2,9,11,30],get_bool:14,get_bytea_escap:14,get_cast_hook:14,get_databas:11,get_datestyl:14,get_decim:14,get_decimal_point:14,get_defbas:14,get_defhost:14,get_defopt:14,get_defpasswd:14,get_defport:14,get_defus:14,get_field:23,get_jsondecod:14,get_namedresult:14,get_notice_receiv:[2,8],get_paramet:[2,8,10,14],get_regtyp:10,get_rel:[2,11],get_tabl:[2,11,26,30],get_typecast:[2,7,9,14,17,22,23],getattnam:2,getlin:11,getlo:[11,13],getnotifi:[2,11],getresult:[2,7,8,10,11,14,26,30],gif:14,gil:2,ginger:27,give:[2,7,8,10,14,17,26],given:[9,10,11,14,19,22,23,24,29],glad:1,glanc:7,global:[2,7,9,14,20,23],gmake:32,good:[6,17,26],got:2,grab:7,grain:10,grant:31,grapefruit:30,greatli:2,greet:17,group:[1,26],guarante:10,guid:13,guido:22,had:[2,10,14,17,19],hal:17,hand:[25,29],handl:[2,8,11,12,14,23],handler:[2,11],happen:[2,7,9,14],hardcod:16,harri:2,has:[0,2,3,4,6,7,8,10,11,15,17,18,19,21,22,26,27,30,31,32,33],has_table_privileg:[11,30],hash:2,have:[0,1,2,3,4,6,7,8,9,10,14,17,19,24,25,26,27,28,29,30,31,32],haven:6,haystack:17,hayward:26,header:6,heavi:14,heavili:31,hello:[7,17],help:1,helper:[2,10,11,24],here:[3,7,8,10,14,17,23,26,27],herebi:31,hereund:31,hex:24,hide:[8,13],hierarchi:[2,6],high:[4,33],high_pai:27,higher:[2,4,7,10,25],highli:33,hilton:2,hint:[2,8,14,17],histori:[5,33],hold:[7,14,17,24],homepag:6,hood:26,host:[2,4,8,11,13,22,26,30],hostnam:22,hour:24,how:[2,7,8,17,22,25,26,27,29,30],howev:[2,7,10,17,24,27,30],hstore:[2,7,14,17,24],html:32,http:[0,1,32],huge:10,human:[7,8,17],i386:32,ico:2,idea:32,ident:26,identifi:[11,19,26],idl:8,ignor:[7,10,17,19],ignore_thi:27,imagin:7,img:14,immedi:[10,19],implement:[2,8,13,14,18,19,33],impli:31,implicit:18,implicitli:15,improv:[1,2],incident:31,includ:[2,6,10,14,17,25,29,30,31],includedir:6,incompat:2,increas:2,index:[2,5,6,7,10,16,17,30,32],index_nam:29,indexrelid:29,indic:[10,19,26,27,28],indirect:31,indirectli:4,individu:[1,10,14,22,30],indkei:29,indrelid:29,inf:2,infinit:2,inform:[0,2,5,7,8,9,10,13,14,16,17,18,19,21,23,24,26,29],infrastructur:1,ing:[8,13],inher:7,inherit:28,inhomogen:14,init:2,initcap:30,initi:[11,13,14],inject:[2,7,8,14,17],inlin:[2,7,10],inop:10,input:[2,7,8,10,14,19,24],insensit:26,insert:[2,6,7,11,14,15,17,19,22,24,25,27,28,29,30],insertt:[2,11,26,30],insid:7,instal:[2,4,5],instanc:[2,7,10,12,13,14,15,17,19,22,24,25,26,27,30],instanti:11,instead:[2,7,8,10,14,15,17,19,26,30],instruct:[2,6],int2:[7,17],int2vector:[7,17],int4:[7,17,25,27],int8:[2,7,17,25],integ:[2,7,8,17,22,24,30],integer_datetim:8,integr:22,integrityerror:[2,22],intend:[7,14,17],intens:26,intent:24,interact:33,interest:[10,13,26],interfac:[1,2,4,5,6,8,12,13,19,21,22,25,26,28,29,33],interfaceerror:[17,22],intern:[2,7,8,10,11,14,16,20,29],internal_s:19,internalerror:[8,10,14],interpret:[7,10,14,17,33],interrog:8,intersect:[7,17],interv:[2,7,17,24],intervalstyl:8,introduct:[11,20,28],introspect:19,intuit:2,inv:29,inv_arch:8,inv_read:[8,13,14],inv_writ:[8,13,14],invalid:[2,8,10,13,14,16,18,19],invalid_oid:8,inventory_item:[7,17],inventoryitem:[7,17],invers:2,invok:[11,19],involv:[1,8,10,14,19],ioerror:[13,19],is_superus:8,isinst:2,isn:27,iso:10,isol:19,issu:[1,2,7,19],item:[7,10,17,19],iter:[2,10,19],its:[2,7,8,10,13,14,15,16,17,19,25,26,27,30,31],itself:[2,10,15,22,26],jame:17,jani:24,jarkko:2,java:33,jeremi:2,jerom:2,john:24,johnni:24,johnston:2,join:[1,28],josh:2,journal:21,json:[2,7,11,17,24],json_data:17,jsonb:[2,7,10,17,24],jsondata:24,just:[2,6,7,8,10,15,26,27],justin:2,kavou:2,keep:[2,7,13,15,19],kei:[2,7,11,17,19,22,26,30],kept:19,keyerror:[2,10],keynam:10,keyword:[2,6,10,14,17,22,26,30],kid:[19,24],kind:[10,14,19],know:[8,17,19],known:8,kuchl:21,kwarg:22,l0pht:2,lambda:[2,7,17,22],languag:[27,28,33],lannam:29,larg:[2,6,10,11,12,14,30],largeobject:[8,11,12,14],larger:2,last:[2,7,11,13,17,19],lastfoot:2,later:[2,13],latest:[2,32],latter:19,layer:32,layout:2,lcrypt:6,ld_library_path:4,leak:2,least:[7,17],leav:[8,10],left:[10,26,29],left_opr:29,left_unari:29,len:23,less:2,let:[2,7,17,25,26,27,30],letter:10,level:[2,4,7,8,9,10,14,19,22,23,26,30,33],liabl:31,lib:6,libdir:6,liber:33,libpq:[2,4,6,8,14],librari:[2,4,6,10,17,33],licens:[2,31,33],like:[1,2,4,6,7,10,11,14,17,19,21,22,26,30],limit:[2,10,30,31],line:[2,6,11,14,22],liner:2,link:[1,3],linux:[6,21,32],list:[2,3,6,7,9,11,17,19,22,23,24,26,27,28,30,32],listen:[8,10,15],listfield:11,liter:[2,7,8,10,14,17,24],littl:2,live:6,load:[14,17],local:[4,6,7,10,14,17,26,30],localhost:[2,6,14],locat:[17,25,26],lock:[13,22],locreat:[11,14],log:7,login:[7,26,30],loimport:11,longer:[2,6,26],look:[0,7,8,9,10,14,17,19,22,23,26,32],loop:15,lost:[7,8,10,17,31],lot:2,low:1,lower:[2,4,7,17,26,30],lpq:6,lunch:25,mac:33,made:[2,7,10],madison:25,magic:[7,17],mai:[1,4,6,7,8,9,12,13,14,16,17,19,21,22,23,26,27,30],mail:2,main:[2,15],mainli:8,maintain:[1,2],mainten:31,major:2,make:[2,6,7,8,17,24,26,27,29,30,32],makefil:6,malici:[7,17],manag:[2,10,18,19,33],mandatori:2,mani:[2,8,10,13,14,16,20,26,30,33],manipul:2,manual:[7,8,14,28],map:[7,9,10,17,19,23,30],mariposa:25,mark:11,match:[6,10],matter:[7,17],matthew:2,max:26,maxim:13,maximum:10,mayb:8,mcphee:2,mdy:26,mean:[2,4,10,14,19,30],meaning:14,mechan:[2,7,10,17],meet:25,mejia:2,member:[2,10],memori:[2,11,16,22,26],memoryerror:[8,16],mention:2,merchant:31,mess:29,messag:[1,2,8,13,19],metadata:29,method:[2,4,6,7,8,9,10,11,13,14,17,18,20,22,23,24,26,30],mfc:33,michael:2,microsecond:24,might:[10,17],mikhail:2,mind:7,mingw:0,minor:2,minut:24,miscellan:2,miss:[2,10,17],mistak:17,mit:2,mode:[8,10,13,14],modern:1,modif:[13,31,33],modifi:[10,13,14,31],modul:[2,4,5,6,7,8,9,10,11,12,13,15,20,21,24,26,30,32,33],monei:[2,7,14,17,24],monetari:11,month:24,more:[1,2,6,7,8,10,13,14,16,17,18,19,22,24,25,26,27,30,33],more_fruit:30,most:[6,10,19,26,33],mostli:2,motif:33,motorcycl:3,move:[2,6,13],mspo:2,msvc:2,much:[7,28,30],multi:[2,4,13],multipl:[10,19,26,28,30],mung:[2,10],must:[1,2,4,6,7,8,9,10,14,15,17,19,22,23,24,26],mwa:2,mxdatetim:2,mydb:22,myhost:[14,22],name:[2,6,7,8,9,11,13,15,17,19,22,23,24,25,26,27,29,30],namedresult:[2,8,11,14,26,30],namedtupl:[2,7,17,19],namespac:2,nan:2,natur:[17,30],necessari:[2,9,14,22,23,30],necessarili:22,need:[1,2,6,7,8,10,13,14,15,17,19,23,24,26,30,33],needl:17,neg:[2,13,27],nest:14,net:[2,31,33],netbsd:[0,6,32,33],never:[7,15,17],new_emp:27,newer:[4,12,21],newli:[8,30],newlin:8,next:[7,17,18,20,26],ngp:2,niall:2,nice:[2,26],nicer:2,no_snprintf:2,nobodi:27,non:[2,19],none:[2,8,9,10,13,14,15,17,18,19,22,23,24,26,27],normal:[7,10,14,15,17,26,29],notabl:2,notat:27,note:[1,2,4,6,7,8,9,10,14,16,17,18,19,22,23,25,26,27,30],noth:30,notic:[2,7,11,17,27,33],notif:[2,8,11],notifi:[11,15],notification_handl:11,notificationhandl:[2,10,15],notsupportederror:22,nov:26,now:[2,6,7,17,18,19,25,26,30],nowadai:2,ntupl:[2,11],null_ok:19,num:16,number:[2,8,10,11,14,15,20,22,24,26,30],numer:[2,7,10,11,17,19,22,24],numericoid:2,obj:[10,14,24],object:[2,6,7,9,10,11,12,15,17,20,22,23,26,30,33],oblig:31,obtain:13,obviou:24,obvious:17,occur:[2,10,14,19,22],off:[2,22,26],offici:2,offset:[10,13],often:33,oid:[2,7,9,10,11,13,17,23,24,29,30],old:2,older:[2,6,10,12,33],oleg:3,omit:[19,26,30],on_hand:[7,17],onc:[2,10,26,30],one:[2,7,8,9,10,14,17,19,22,23,24,26,27,29,30],ones:14,ongo:2,onli:[2,3,4,6,7,8,9,10,12,13,14,15,17,19,21,25,26,30],ontario:3,open:[1,2,7,10,11,20,33],opensus:[0,32],oper:[2,6,7,10,14,15,17,18,20,22,24,28,30],operand:29,operationalerror:[8,22],opf:29,opfmethod:29,opfnam:29,oprkind:29,oprleft:29,oprnam:29,oprresult:29,oprright:29,opt:[14,22],optim:19,option:[2,4,6,8,10,11,15,19,22,24,26],order:[2,9,10,14,16,22,26,27,29,30],ordereddict:[10,19,30],ordinari:[2,10,19,30],org:[0,1,31,32],orient:33,origin:26,orm:4,other:[2,7,8,10,14,17,19,22,25,28,30,33],otherwis:[8,10,14,17,19],our:[7,17,26,32],out:[1,2,7,10,15,17,22,26,27,31],output:[2,14,19,24,26,30],outsid:10,over:[2,10,19],overflow:[8,10],overhead:2,overlap:[7,17],overlook:[7,17],overpaid:27,overrid:[10,14],overridden:2,overview:1,overwrit:19,own:[7,10,17,18,26],packag:[0,2,6,32],page:[3,5,12],pai:25,pair:[10,23],pami:2,paragraph:31,param:[7,17],paramet:[2,9,11,13,14,15,16,19,20,22,23,24,26,30],paramstyl:22,paramt:7,parent:10,parenthes:14,pars:[14,23,29],parse_int:17,parser:[2,10,11],part:[2,3,4,6,10,12,20,21,22,23,24,30],parti:31,particip:32,particular:[2,10,14,22,24,31],particularli:[2,16,17],pascal:[31,33],pass:[2,7,8,9,10,14,15,17,19,22,23,24,26,30],passwd:[7,14,22,26,30],password:[2,4,7,11,22,30],past:32,path:[4,6],patrick:2,pay_by_extra_quart:25,pay_by_quart:25,payload:[2,8,15],peer:1,peifeng:2,pend:18,pep:[4,21],per:19,percent:2,perform:[2,7,10,14,18,19,30],perl:33,perman:30,permiss:[2,31],peter:2,pg_:29,pg_aggreg:29,pg_am:29,pg_amop:29,pg_attribut:29,pg_authid:29,pg_class:29,pg_config:6,pg_databas:29,pg_index:29,pg_languag:29,pg_oper:29,pg_opfamili:29,pg_proc:29,pg_type:[9,23,29],pgcnx:[8,13],pgdb:[2,4,6,10,12,17,18,19,21,22,23,24,30,32],pgdbtypecach:2,pgext:2,pginc:6,pglarge_writ:2,pglib:6,pgmodul:[2,6,32],pgnotifi:[2,15],pgqueryobject:2,pgserver:[26,30],pgsql:6,pgtype:[9,32],pheng:[2,15],phone:[8,10,14],pick:[10,14,22,32],pictur:14,pid:[8,15],ping:6,pkei:[2,11],pkgsrc:32,place:[6,7],placehold:[7,10],platform:[4,6,33],pleas:[0,1,7,8,14,17,30,32],plu:[25,30],plug:14,point:[2,3,7,14,15,17,18,19,26],poll:15,ponder:17,pong:6,popul:[7,17,25,27],port:[0,2,4,8,11,22,26,30,32],posgresql:14,posit:[2,7,8,10,13,14,16,19],possibl:[2,6,7,10,17,19,27,31],post1:2,postgr:[2,6,29],postgresql:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,17,18,19,20,21,23,24,25,26,27,29,30,32,33],power:33,pprint:26,pqconsumeinput:2,pqescapebyteaconn:2,pqescapeidentifi:2,pqescapeliter:2,pqescapestringconn:2,pqfreemem:2,prcp:26,pre:[6,32],preced:[10,22],precipit:26,precis:[2,14,19],precompil:6,predic:26,prefer:[8,10],prefix:[10,15],preload:2,prepar:19,present:[10,25],preserv:10,pretti:2,prevent:[10,14],previou:[7,11,14,17,19],previous:[10,13],price:[7,17],primari:[2,7,8,11,17,26,30],primer:[3,5],print:[2,8,10,25,26,27,29,30],printra:2,privat:2,privileg:[2,11],proargtyp:29,probabl:26,problem:[1,2,6,7,8,13,22],procedur:20,process:[1,2,7,10,11,19,22,26],procnam:19,produc:[15,19],profit:31,program:[2,5,13,14,21,22,29,30,33],programm:[13,22,33],programmingerror:[2,7,8,10,17,22,26],progress:8,project:27,prolang:29,prompt:14,pronam:29,pronarg:29,proper:[2,10,14,16,24],properli:[2,7,10,17],properti:[10,14],propos:[1,10],prorettyp:29,protect:22,protocol:[2,8,18,19],protocol_vers:[2,8],prototyp:2,provid:[2,4,7,8,9,10,12,13,14,16,17,19,21,22,23,24,30,31],pryzbi:2,psinc:6,pub:32,pure:6,purpos:[1,2,31],put:[7,10,14,17],putlin:11,py2:32,py3:32,py3c:32,pyarg_parsetupleandkeyword:2,pyd:6,pyformat:22,pygres95:[2,33],pygresql:[2,3,6,7,9,10,12,14,15,16,17,21,22,23,24,25,26,28,29,31],pyinc:6,pyos_snprintf:2,pypi:32,python:[0,1,2,4,8,9,10,11,13,14,16,19,20,21,22,23,24,26,30,32,33],pythonpath:6,qiu:2,qualif:27,qualifi:2,quarter:25,queri:[2,6,7,11,12,14,17,20,24,25,26,27,29,30,33],query_format:[2,7,11,14],question:1,quickli:[2,8,11,14,26,30,33],quirk:14,quit:17,quot:[2,7,10,14,17],race:10,raini:26,rais:[2,8,10,13,14,16,18,19,20],rang:[22,26],rank:16,rare:7,rather:[2,10,18,19,22],raw:[7,10,14,17,22],reach:15,read:[6,7,8,11,14,17,19,26,32],readabl:[7,8,17],readi:[2,6],readm:[0,2,32],real:[7,8],realli:8,reason:[2,7,17],rebuild:6,receiv:[2,11,14,15],reclaim:10,recommend:4,record:[2,7,11,17,24,26],recreat:29,recurr:13,recurs:2,redefinit:2,reduc:2,redund:2,refer:[0,8,10,13,14,19,25,30,31],referenc:10,reflect:10,reformat:2,regard:[1,20,26],regist:[7,17],regoper:29,regress:2,regtyp:[9,10],regular:[2,9,11,29],rel:14,relat:[2,11,22,26,33],releas:[2,11,32],reli:2,relid:[9,23],relkind:29,relnam:[8,29],reload:10,remain:19,remark:[11,20,33],rememb:[7,8,13,17],remot:6,remov:[2,6,10,28,30],renam:[2,16,19,33],reopen:[2,10,14,17,22],reorder:2,replac:[2,10,19],report:[2,8],repres:[2,10,14,19,22,24],represent:[7,10,14,17,19,30],request:[1,2,7,8,10,12,13,14,17,19,30],requir:[6,7,10,17],reset:[9,10,11,14,17,22,23],reset_typecast:[7,9,14,17,20,23],resolut:11,resort:[7,17,33],respect:2,respond:[18,19],rest:[6,32],restart:10,reston:2,restor:[2,10],restrict:[10,19,26],result:[2,7,8,10,11,12,14,17,20,24,26,27,29,30],retain:19,retri:2,retriev:[11,25,28,30],return_typ:29,reus:[2,8,13],revers:[10,14],revert:2,review:1,reviv:2,rewrit:2,rewrot:2,rgb:3,richard:2,ride:[3,10],right:[7,14,29],right_opr:29,right_unari:29,risk:14,rlawrenc:2,roadmap:1,roll:[2,10,20],rollback:[2,11,20,30],rolnam:29,root:6,row:[2,6,7,8,11,16,17,20,25,26,27,29,30],row_factori:[2,19],rowcount:[2,20],rowid:24,rpm:[6,32],rsplit:17,rule:10,run:[0,2,6,7,9,11,14,15,17,22,23,32,33],sacramento:25,safe:[2,4,15,22,30],sal_emp:25,salari:27,sam:27,same:[2,4,7,10,13,14,15,16,17,18,19,26,27,30],san:[25,26],satisfi:26,save:11,savepoint:[2,11],saw:[17,26],scalabl:33,scalar:[7,10,30],scale:[2,19],scan:10,scene:7,schedul:25,schema:[2,29],scheme:33,schuller:2,scott:[26,30],script:[32,33],search:[5,6],search_path:2,search_term:32,second:[10,15,17,24],secondari:8,section:[7,17,18,25,26,29,32],secur:[2,14],see:[1,2,6,7,9,10,12,13,18,23,26,30,32,33],seek:[11,14],seek_cur:[13,14],seek_end:[13,14],seek_set:[13,14],seem:[6,7],seen:7,select:[2,6,7,8,10,14,17,19,24,25,26,27,29,30],self:[7,10,17,19],send:[1,2,3,7,8,11,13,26,30],sens:[7,17],sensit:26,sent:[2,8,10,15,17],sep:19,separ:[2,7,10,17,19,26],seq_of_paramet:19,sequenc:[10,19,30],serial:[7,10,17,24,30],serializ:[14,24],serv:[4,10,28,33],server:[6,11,13,19,22],server_encod:8,server_vers:[2,8],servic:32,session:[10,14],session_author:8,set:[2,4,6,7,9,11,13,14,15,17,18,20,23,26,30],set_arrai:[2,11],set_bool:[2,7,11],set_bytea_escap:[2,11],set_cast_hook:11,set_datestyl:11,set_decim:[2,7,11],set_decimal_point:11,set_defbas:11,set_defhost:11,set_defopt:11,set_defpasswd:11,set_defport:11,set_defus:11,set_jsondecod:[2,7,10,11],set_namedresult:11,set_notice_receiv:[2,11],set_paramet:[2,11,14],set_row_factory_s:2,set_typecast:[2,7,9,11,17,22,23],setof:27,settabl:10,setup:[6,8,14,32],sever:[8,10,14,22,26,29,30],shall:[9,10,14,19,22,23,24,26,31],share:[4,6,13],sharedinstal:6,sharpen:2,shoe:27,shortcut:10,should:[2,6,7,10,13,14,17,19,22,26,29],show:[3,25,29,30],side:[15,19],sig:[4,8,21,32],sign:2,signal:15,signatur:19,signific:[8,13],silent:14,similar:[7,10,20,30],simon:2,simpl:[2,3,7,8,9,10,12,13,24,26,27,29],simpler:[2,7],simplest:26,simpli:[2,6,7,8,10,14,17,19,30],simplic:2,simplif:2,simplifi:[2,10],sinc:[2,7,8,10,13,14,15,16,17,26],singl:[2,7,10,14,15,19,22,26,30],singleton:24,siong:[2,15],site:6,situat:25,size:[2,11,19,23],skip:10,slight:17,small:[2,30],smallint:[2,24],smart:2,smooth:2,snprintf:2,socket:[2,11],softwar:[31,32,33],solut:[7,17,33],some:[2,3,4,6,7,8,10,12,13,14,17,22,24,25,26,28,29,30],someth:[6,7,17],sometim:[9,14,17,22,23],somewhat:2,soon:7,sophist:27,sort:[10,26],sourc:[3,14,22,32,33],space:10,special:[10,14,15,24,31],specif:[2,4,7,10,14,17,21,22,24,31],specifi:[2,8,9,10,14,15,19,22,23,26,30],speed:2,speedup:2,sphinx:[2,32],split:[7,17,30],sporled:2,sql:[2,4,7,11,17,22,24,26,28,29,33],sqlalchemi:[2,4],sqlstate:[2,8,19,22],sqrt:[7,17],stamp:24,stand:7,standard:[2,4,10,14,17,20,22,23,24,30],standard_conforming_str:8,starship:2,start:[2,3,4,7,10,13,15,16,17,18,26,27,30,33],startup:8,state:[2,11,14,22,25,30],statement:[2,7,8,10,17,18,19,22,26,28,30],statu:8,step:5,still:[2,7,10,14,17,19,33],stop:[10,15],stop_:15,stop_ev:[10,15],storag:4,store:[3,7,10,14,20,29],str:[2,7,8,9,10,13,14,15,16,17,19,22,23],straight:2,stream:[2,19],string:[2,7,9,11,13,16,17,19,22,23,24,26,30],strlen:2,strptime:8,strtol:2,structur:2,studio:0,style:[2,7,11,26],stylist:2,subarrai:25,subclass:[2,10,18,19],subdirectori:6,submit:[1,2],subsequ:[2,10],subset:[10,19,26],substitut:8,subtl:[14,17],subvers:1,success:14,suggest:[2,8],suit:32,suitabl:[7,14,17,22],sum:27,suppli:[2,8,10,14],supplier_id:[7,17],support:[2,4,6,8,9,10,11,14,16,19,20,22,27,31,32,33],suppos:26,sure:[2,6,14,22,26,27],svn:1,symlink:6,sympi:[7,17],synchron:[11,15],syntax:[2,7,8,14,17,22,26,33],syntaxerror:14,system:[2,6,7,8,11,17,28,30,33],tabl:[2,7,9,11,14,16,17,19,22,23,24,25,27,28,29,30],tag:[8,14],take:[2,4,7,8,9,10,14,22,23,27],taken:[2,10,28],tar:[0,32],tarbal:6,target:[26,27],tbryan:2,tcl:33,team:[31,33],tediou:[7,17],tell:[11,30],temp:2,temp_avg:26,temp_hi:26,temp_lo:26,temperatur:26,temporari:[2,10,26],tempt:7,temptab:26,terekhov:2,term:31,termin:6,test:[0,2,6,19,32,33],testdb:[14,26,30],text:[2,7,10,11,17,19,24,25,27,30,32],textual:19,than:[2,7,10,13,14,17,18,19,22,24,27,30,33],thank:2,thei:[2,7,8,9,10,14,19,23,24,26,28,29,30],them:[2,7,8,10,14,17,18,19,22,30,33],themselv:[7,17],therefor:[4,7,14,17,22],thi:[0,1,2,4,6,7,8,9,10,13,14,15,16,17,18,19,20,23,25,26,28,29,30,31,33],thilo:[2,6],thing:[0,7,17,26,30],think:[7,17],third:[25,26],those:26,though:[2,13,17],thought:30,thread:[2,4,13,15,22],threadsafeti:22,three:[6,12],through:[1,2,7,8,10,14,19,32],thu:[8,13,22],tick:24,ticket:1,tiger:[26,30],time:[2,7,11,15,17,20,24,26,30],timedelta:[7,17],timefromtick:24,timelin:1,timeout:[10,15],timestamp:[2,7,8,17,24],timestampfromtick:24,timestamptz:[7,17],timetz:[7,17],timezon:8,toast:10,todai:2,togeth:[10,15],toi:27,toni:2,too:[7,8,10,13,14,16],tool:6,toolkit:4,top:6,torppa:2,tpye:19,trac:1,track:1,trail:8,train:25,trans_act:[8,14],trans_idl:[8,14],trans_inerror:[8,14],trans_intran:[8,14],trans_unknown:[8,14],transact:[2,11,14,18,19,22],transform:[7,19],treat:[2,17],tree:2,tri:[2,7,8,17,19],trigger:[8,10],triplet:8,trove:2,truncat:[2,11,22],trunk:1,tty:2,tuhnu:2,tupl:[2,7,8,10,11,17,19,26,27,30],turn:[2,14],tutori:[2,14,21,30],two:[2,4,6,7,14,17,25,26,27,31],txt:0,typ:[7,9,14,22,23],type:[2,6,8,11,12,13,16,18,19,20,22,25,26,28,32,33],type_cach:[17,18,22,23],type_cod:[2,19,23,24],typecach:[17,18,20,22],typecast:[2,8,9,10,11,18,20,23],typeerror:[8,10,13,14,16,19],typelem:29,typnam:29,typown:29,typrelid:29,typtyp:9,tzinfo:24,ubuntu:0,ugli:2,unari:29,unchang:10,uncom:6,und:10,under:[0,2,10,22,26,33],underli:[2,8],underscor:16,understand:[7,17,23],undocu:2,unescap:[2,11],unescape_bytea:[2,11],unexpect:22,unic:2,uninstal:6,uniqu:10,unit:[0,2,32],unix:[2,6,13],unknown:[2,8,16,26],unless:[8,9,10,19,23],unlik:10,unlink:[2,11],unlisten:15,unnam:10,unnecessari:2,unpack:6,unprocess:14,unqualifi:10,unsupport:8,until:[10,15],untrustworthi:14,unus:[2,18,19],unwant:14,updat:[2,7,8,11,14,19,28,29,30,31],upper:10,upsert:[2,11],url:[3,4],usabl:33,usag:19,use:[1,2,3,4,6,7,8,9,11,12,15,17,18,19,21,22,23,25,26,28,30,31,33],use_regtyp:[2,9,11],used:[2,6,7,10,11,13,15,16,17,18,19,22,23,26,27,30],useful:[2,7,8,10,13,14,16,17,21],user:[2,7,8,10,11,22,25,26,28,30],user_t:7,usernam:4,uses:[2,3,7,8,10,14,17,22,24,30],using:[1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,22,23,24,25,26,28,30],usr:[2,6],usual:[1,2,6,7,8,14,17,19],util:[2,4],uuid:[2,7,17,24],vacuum:10,val:10,valid:[2,8,13,16,19],valu:[2,6,7,8,9,11,13,15,17,19,22,23,24,25,26,27,29,30],valueerror:[8,10,13,14,16,19],varchar:[7,17,24,26,27,30],variabl:[2,4,6,10,13,14,19],variat:17,variou:[2,10,18,32,33],vega:25,veri:[2,8,13,14,19,26,33],verifi:[7,17,30],version:[4,6,7,8,9,10,14,15,16,17,18,19,22,23,24,33],via:[2,7,8,17,19,31,33],vies:10,view:[2,3,11],violat:2,visibl:[10,19],visual:0,volum:1,volunt:1,vulner:[14,17],wai:[2,4,6,7,8,10,13,17,18,26,29,30,32],wait:[10,15],want:[1,2,6,7,8,10,12,13,14,15,17,18,19,22,26,29,30],warn:[2,7,8,13,22],warranti:31,weather:26,web:13,welcom:1,well:[2,10,22,33],were:[2,7,14,17,28],what:[5,7,8,10,17,26],whatev:13,when:[1,2,6,7,8,10,14,15,17,19,22,23,24,26],whenc:13,whenev:[8,18,19],where:[2,6,7,8,10,14,17,19,22,25,26,27,29,30,33],wherein:14,whether:[2,8,10,11,15,19],which:[2,4,6,7,8,9,10,12,14,17,19,22,23,24,26,29,30],who:31,whole:[8,30],whose:10,win32:[2,32],win:32,window:[0,2,6,33],within:[10,11],without:[2,7,8,14,15,17,18,30,31],won:[2,13,14,26],work:[2,6,7,10,17],world:7,worri:[2,8],wors:[7,17],would:[1,2,6,7,10,14,17,26],wrap:[2,10,14,24],wrapper:[2,4,6,8,11,12,14,24,26,30,32],write:[2,10,11,17,19,26],written:[3,8,13,15,21,31,33],wrong:[19,22],www:[1,32],x11:33,yahoo:2,year:[24,33],yet:[8,19],yield:[2,17,19],you:[0,1,2,3,4,6,7,8,9,10,12,13,14,15,17,18,19,21,22,23,24,25,26,27,29,30,32,33],your:[4,6,7,10,14,17,18,26,29,30],zero:[22,25],zip:19,zwei:6},titles:["PyGreSQL Announcements","PyGreSQL Development and Support","ChangeLog","Examples","General PyGreSQL programming information","The PyGreSQL documentation","Installation","Remarks on Adaptation and Typecasting","Connection \u2013 The connection object","DbTypes \u2013 The internal cache for database types","The DB wrapper class","<code class=\"docutils literal notranslate\"><span class=\"pre\">pg</span></code> \u2014 The Classic PyGreSQL Interface","Introduction","LargeObject \u2013 Large Objects","Module functions and constants","The Notification Handler","Query methods","Remarks on Adaptation and Typecasting","Connection \u2013 The connection object","Cursor \u2013 The cursor object","<code class=\"docutils literal notranslate\"><span class=\"pre\">pgdb</span></code> \u2014 The DB-API Compliant Interface","Introduction","Module functions and constants","TypeCache \u2013 The internal cache for database types","Type \u2013 Type objects and constructors","Examples for advanced features","Basic examples","Examples for using SQL functions","A PostgreSQL Primer","Examples for using the system catalogs","First Steps with PyGreSQL","Copyright notice","Download information","Welcome to PyGreSQL"],titleterms:{"boolean":14,"class":10,"default":14,"export":13,"function":[14,22,27,29],"import":8,"new":[18,32],"return":[10,14,16,18],The:[5,8,9,10,11,15,18,19,20,23],abandon:8,access:1,adapt:[7,17],advanc:25,aggreg:[26,29],all:19,alon:6,announc:0,api:[20,30],arrai:[14,25],arrays:19,assum:14,attribut:[8,10,13,18,19,29],auxiliari:15,back:18,base:[27,29],basic:26,been:14,begin:10,binari:[6,14],bool:14,bug:1,build:[6,8],built:6,bytea:[10,14],cach:[9,23],call:19,callproc:19,cancel:8,cast_arrai:14,catalog:29,chang:32,changelog:2,check:10,classic:[11,30],clear:10,client:8,close:[8,13,18,19],column:19,command:[8,10],commit:[10,18],compil:6,compliant:20,composit:27,conflict:10,connect:[8,10,14,18,22,26],constant:[14,22],constructor:24,content:[5,11,20,28],control:22,convers:[14,16],copyright:31,creat:[8,10,26,27],current:[8,32],cursor:[18,19],custom:[8,14],data:[7,10,14,17,26],databas:[8,9,10,14,19,23,26],date:[8,14],date_format:8,dbtype:9,decim:14,decod:[10,14],decode_json:10,defin:29,delet:[10,26],descript:19,detail:19,determin:10,develop:[1,32],dict:10,dictionari:[10,16],dictresult:16,distribut:[6,32],distutil:6,document:5,download:32,empti:10,encod:10,endcopi:8,error:22,escap:[10,14],escape_bytea:14,escape_liter:10,escape_str:14,exampl:[3,25,26,27,29],execut:[8,10,19],executemani:19,fallback:14,famili:29,fast:14,featur:25,fetch:19,fetchal:19,fetchmani:19,fetchon:19,field:16,fieldnam:16,fieldnum:16,file:[8,13,32],fileno:8,first:30,fix:14,format:[8,10,14],from:[6,8,10],futur:32,gener:[4,6],get:[8,10,13,14,16,22],get_as_list:10,get_attnam:10,get_databas:10,get_rel:10,get_tabl:10,getlin:8,getlo:8,getnotifi:8,getresult:16,given:8,global:22,handl:[10,13],handler:[10,15],has:14,has_table_privileg:10,helper:14,home:[1,32],host:14,identifi:10,indic:[5,29],inform:[4,32],inherit:25,initi:10,insert:[8,10,26],insertt:8,instal:[6,32],instanti:15,interfac:[11,20,30],intern:[9,23],interpret:6,introduct:[12,21],invok:15,join:26,json:[10,14],kei:10,languag:29,larg:[8,13],largeobject:13,last:8,like:13,line:8,list:[1,8,10,14,16,29],listfield:16,locreat:8,loimport:8,mail:1,mani:19,manual:6,mark:14,memori:10,method:[15,16,19],modul:[14,22],monetari:14,multipl:27,name:[10,14,16],namedresult:16,next:19,notic:[8,31],notif:[10,15],notifi:8,notification_handl:10,ntupl:16,number:[16,19],numer:14,object:[8,13,14,16,18,19,24],oid:8,older:32,open:[13,14,22],oper:[19,29],option:14,other:26,paramet:[7,8,10,17],parser:14,part:[18,19],password:14,pgdb:20,pip:6,pkei:10,port:14,postgresql:[14,22,28],previou:16,primari:10,primer:28,privileg:10,procedur:19,process:8,program:4,project:[1,32],putlin:8,pygresql:[0,1,4,5,11,30,32,33],python:[6,7,17],queri:[8,10,16,19],query_format:10,quickli:10,rais:22,read:[10,13],receiv:8,record:14,regard:19,regular:10,relat:10,releas:[0,10],remark:[7,17],remov:[26,27],repositori:1,reset:8,reset_typecast:22,resolut:10,result:[16,19],retriev:[10,14,26],roll:18,rollback:[10,18],row:[10,19],rowcount:19,run:10,save:13,savepoint:10,seek:13,send:15,server:[8,14],set:[8,10,19,22],set_arrai:14,set_bool:14,set_bytea_escap:14,set_cast_hook:14,set_datestyl:14,set_decim:14,set_decimal_point:14,set_defbas:14,set_defhost:14,set_defopt:14,set_defpasswd:14,set_defport:14,set_defus:14,set_jsondecod:14,set_namedresult:14,set_notice_receiv:8,set_paramet:10,set_typecast:14,similar:19,site:[1,32],size:13,socket:8,sourc:[1,6],sql:[8,10,14,27],stand:6,standard:[18,19],state:8,statement:27,step:30,store:19,string:[8,10,14],style:14,support:[1,7,17],synchron:8,system:[10,29],tabl:[5,8,10,26],tell:13,text:14,thi:[22,27],time:[10,19],tracker:1,transact:[8,10],truncat:10,tupl:[14,16],type:[7,9,10,14,17,23,24,27,29],typecach:23,typecast:[7,14,17,22],unescap:[10,14],unescape_bytea:[10,14],unlink:13,updat:[10,26],upsert:10,use:[10,14],use_regtyp:10,used:[8,14],user:[14,29],using:[27,29],valu:[10,14,16],version:[0,2,32],vesion:2,view:10,welcom:33,were:27,whether:14,within:14,wrapper:10,write:[8,13]}})