Search.setIndex({envversion:48,filenames:["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"],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:{"__version__":[14,5,1,""],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,""],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,"__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,"boolean":[2,9,10,11],"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],"default":[2,6,7,9,10,11],"export":11,"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],"import":[2,6,7],"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],"null":[2,14,17,19,24],"public":[2,26,30],"return":[2,7,8,9],"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],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,accomplish:17,accord:[8,9,23],accordingli:[7,17,24],account:[1,2,14],achiev:[2,7,17,26],activ:[1,14],actual:[2,10,17,29],adam:2,adapt:2,add:[1,2,6,7,10,14,17,22,29,30],add_em:27,addit:[2,9,14,22,23,26,30],addition:24,adjac:14,adjust:10,advanc:2,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,aggfnoid:29,aggreg:2,ago:2,agreement:31,alet:2,algorithm:19,alias:26,all:[1,2,6,7,8,9,10,12,13,14,15,17,18],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],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],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],array_low:[7,17],assign:19,associ:[9,13,15,19,23],assort:2,assum:[7,10,11],asynchron:15,atom:10,attack:[7,14,17],attempt:[18,19],attisdrop:29,attnam:[2,9,29],attnum:29,attrelid:29,attribut:2,atttypid:29,augment:2,author:31,authorit:[4,21],auto:18,autocommit:30,automat:[2,6,7,8,10,14,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],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],basi:31,basic:[2,7,9,10,12,14,17,25],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],befor:[2,7,10,13,19,27],begin:2,beginn:4,behavior:[2,7,10,17,19],behind:7,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,binary_op:29,bind:[7,24],blank:2,block:[8,10],bob:14,bojnourdi:2,bond:17,bookkeep:29,bool:[2,7,10,11],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],build:2,build_row_factori:19,builder:19,built:[0,2],bump:2,bunch:30,bytea:[2,7],bytes_l:24,cach:[2,8],cain:[0,1,31,33],calcul:[7,17],call:[2,4,6,7,8,9,10,13,14,15,17,18],callabl:[8,14,19],callback:[8,10,14,15],caller:[2,10,15],callproc:2,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],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,channel:15,chapter:[2,28,32],charact:[7,10,14,19],charli:2,cheap:8,check:[1,2,7,8],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],claus:[2,7,10,26],clean:[2,7],clean_emp:27,cleanli:2,cleanup:2,clear:[2,7],client:[2,4,6],client_encod:8,client_min_messag:8,close:2,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],com:2,combin:33,come:[2,6,8,14,15,22],comma:14,command:[1,2,6,7],comment:1,commerci:33,commit:2,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],complic:26,compos:14,composit:[2,7,9,10,13,14,17,23],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],conform:10,confus:[2,26],connect:[2,4,6,7],connection_handl:15,consequenti:31,consid:[2,7,22],consider:19,consist:[2,4],constant:[2,8,10,11,13],constraint:2,construct:[14,24],constructor:[2,17,20],consult:25,contain:[2,6,7,8,10,14,17,19,22,24],context:[1,2,7,10,14,18,19],continu:[7,9,23],contribut:[2,31],contributor:1,control:[2,10,20],conveni:[2,4,10,12,26,30],convers:[2,7,11],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],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],creation:[2,8,13],csua:2,csv:19,cur:[17,19,30],currenc:14,current:[1,2,6,7],current_timestamp:2,cursor:[2,13,17],cursor_typ:[18,19],custom:[2,7],customiz:2,cuteri:2,cvsweb:32,dai:[24,26],damag:31,danger:7,darci:[0,31,33],dat:14,data:2,databas:[0,2,3,4,6,7],databaseerror:[2,19,22],dataerror:22,datastr:[10,14],date:[2,7],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,dbutil:4,deactiv:[2,14],deal:14,dealloc:13,debug:2,decim:[2,7,11],decod:2,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],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],deseri:[10,14],design:14,destroi:10,desynchron:8,detail:[2,6,7,8,9,10,17,18],detect:24,determin:7,devel:6,dice:[7,17],dict:[2,7],dictcursor:19,dictionari:[2,7,9],dictresult:[2,8,10,11],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,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],doe:[2,7,10,14,17,24,26,30],doesn:[2,6,8],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],enabl:[2,9,10,14],encapsul:[2,10],encode_json:10,end:[10,30],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],escap:[2,7,8],escape_byt:10,escape_bytea:[10,11],escape_identifi:10,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],except:[1,2,7,10,14,18,19,22,33],exclud:10,execut:[2,6,7],executemani:2,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],fed:14,fee:31,feet:25,fetch:[2,10,17],fetchal:[2,17],fetchon:17,few:[2,3,10,14],fewer:19,field:[2,8,9,10,11,14],fieldnam:11,fieldnum:11,fig:30,file:[0,2,3,6],fileno:2,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],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],freeli:33,from:[2,4],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],geometr:[7,17],gerhard:2,get:[1,2,7],get_arrai:14,get_as_dict:[2,7,10,30],get_as_list:2,get_attnam:[2,9],get_bool:14,get_bytea_escap:14,get_cast_hook:14,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,get_tabl:2,get_typecast:[2,7,9,14,17,22,23],getattnam:2,getnotifi:2,getresult:[2,7,8,10,11,14],gif:14,gil:2,ginger:27,give:[2,7,8,10,14,17,26],glad:1,glanc:7,global:[2,7,9,14,20],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],handler:2,happen:[2,7,9,14],hardcod:16,harri:2,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],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],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,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,indirect:31,indirectli:4,individu:[1,10,14,22,30],indkei:29,indrelid:29,inf:2,infinit:2,inform:[0,2],infrastructur:1,ing:[8,13],inher:7,inhomogen:14,init:2,initcap:30,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],insertt:2,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],interfaceerror:[17,22],intern:[2,7,8],internal_s:19,internalerror:[8,10,14],interrog:8,intersect:[7,17],interv:[2,7,17,24],intervalstyl:8,introduct:11,introspect:19,intuit:2,inv:29,inv_arch:8,inv_read:[8,13,14],inv_writ:[8,13,14],invalid:[8,10,13,14,16,18,19],invalid_oid:8,inventory_item:[7,17],inventoryitem:[7,17],invers:2,invok:11,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],itself:[2,10,15,22,26],jame:17,jani:24,jarkko:2,java:33,jeremi:2,jerom:2,john:24,johnni:24,join:1,journal:21,json:[2,7],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],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],lannam:29,larg:[2,6],largeobject:[8,11,12],larger:2,last:[2,7],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:[31,33],like:[1,2,4,6,7,10,11],limit:[2,10,30,31],line:[2,6],liner:2,link:[1,3],linux:[6,21,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],log:7,login:[7,26,30],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],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],manipul:2,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,memoryerror:[8,16],mention:2,merchant:31,mess:29,messag:[1,2,8,13,19],metadata:29,meth:19,method:[2,4,6,7,8,9,10,11,13,14],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],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],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],namedresult:[2,8,11,14],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,33],newli:[8,30],newlin:8,next:[7,17,18],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],notif:[2,8],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],numer:[2,7,10,11],numericoid:2,obj:[10,14,24],object:[2,6,7],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],old:2,older:[2,6,10,12],oleg:3,omit:[19,26,30],on_hand:[7,17],onc:[2,10,26,30],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],opensus:[0,32],oper:[2,6,7,10,14,15,17,18],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],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],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,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],parti:31,particip:32,particular:[2,10,14,22,24,31],particularli:[2,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],past:32,path:[4,6],patrick:2,pay_by_extra_quart:25,pay_by_quart:25,payload:[2,8,15],peer:1,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],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,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],posgresql:14,posit:[2,7,8,10,13,14],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],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],previous:[10,13],price:[7,17],primari:[2,7,8],primer:[3,5],print:[2,8,10,25,26,27,29,30],printra:2,privat:2,privileg:2,proargtyp:29,probabl:26,problem:[1,2,6,7,8,13,22],process:[1,2,7],procnam:19,produc:[15,19],profit:31,program:2,programm:[13,22,33],programmingerror:[2,7,8,10,17,22,26],progress:8,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],py2:32,py3:32,py3c:32,pyarg_parsetupleandkeyword:2,pyd:6,pyformat:22,pygres95:[2,33],pyinc:6,pyos_snprintf:2,pypi:32,python:[0,1,2,4],pythonpath:6,qualif:27,qualifi:2,quarter:25,queri:[2,6,7],query_format:[2,7],question:1,quickli:[2,8],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],readabl:[7,8,17],readi:[2,6],readm:[0,2,32],real:[7,8],realli:8,reason:[2,7,17],rebuild:6,receiv:2,reclaim:10,recommend:4,record:[2,7,11],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,regist:[7,17],regoper:29,regress:2,regtyp:[9,10],regular:[2,9],rel:14,relat:2,reli:2,relid:[9,23],relkind:29,relnam:[8,29],reload:10,remain:19,rememb:[7,8,13,17],remot:6,remov:[2,6,10],renam:[2,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_typecast:[7,9,14,17,20],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],retain:19,retri:2,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],rollback:2,rolnam:29,root:6,row:[2,6,7,8],row_factori:[2,19],rowcount:2,rowid:24,rpm:[6,32],rsplit:17,rule:10,run:[0,2,6,7,9],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,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,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],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,server_encod:8,server_vers:[2,8],servic:32,session:[10,14],session_author:8,set:[2,4,6,7],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,set_paramet:2,set_row_factory_s:2,set_typecast:[2,7,9,11],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],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],situat:25,size:[2,11],skip:10,slight:17,small:[2,30],smallint:[2,24],smart:2,smooth:2,snprintf:2,socket:2,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],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],sqlalchemi:[2,4],sqlstate:[2,8,19,22],sqrt:[7,17],stamp:24,standard:[2,4,10,14,17],standard_conforming_str:8,starship:2,start:[2,3,4,7,10,13,15,17,18,26,27,30,33],startup:8,state:2,statement:[2,7,8,10,17,18,19,22,26],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],str:[2,7,8,9,10,13,14,15,16,17,19,22,23],straight:2,stream:[2,19],string:[2,7],strlen:2,strptime:8,strtol:2,structur:2,studio:0,style:[2,7,11],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],suppos:26,sure:[2,6,14,22,26,27],svn:1,symlink:6,sympi:[7,17],syntax:[2,7,8,14,17,22,26,33],syntaxerror:14,system:[2,6,7,8],tabl:2,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,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],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],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],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,transform:[7,19],treat:[2,17],tree:2,tri:[2,7,8,17,19],trigger:[8,10],triplet:8,truncat:2,trunk:1,tty:2,tuhnu:2,tupl:[2,7,8,10,11],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],type_cach:[17,18,22,23],type_cod:[2,19,23,24],typecach:[17,18,20,22],typecast:2,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],understand:[7,17,23],undocu:2,unescap:2,unescape_bytea:2,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:11,unlisten:15,unnam:10,unnecessari:2,unnessesari:2,unpack:6,unprocess:14,unqualifi:10,unsupport:8,until:[10,15],untrustworthi:14,unus:[2,18,19],unwant:14,updat:[2,7,8],upper:10,upsert:2,url:[3,4],usabl:33,usag:19,use_regtyp:[2,9],user:[2,7,8,10,11],user_t:7,usernam:4,usr:[2,6],usual:[1,2,6,7,8,14,17,19],util:4,utilits:2,uuid:[2,7,17,24],vacuum:10,val:10,valid:[2,8,13,19],valu:[2,6,7,8,9],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],via:[2,7,8,17,19,31,33],view:[2,3],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],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],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,6,7,10,14,17,26],wrap:[2,10,14,24],wrapper:[2,4,6,8],write:2,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 &#8211; The connection object","DbTypes &#8211; The internal cache for database types","The DB wrapper class","<code class=\"docutils literal\"><span class=\"pre\">pg</span></code> &#8212; The Classic PyGreSQL Interface","Introduction","LargeObject &#8211; Large Objects","Module functions and constants","The Notification Handler","Query methods","Remarks on Adaptation and Typecasting","Connection &#8211; The connection object","Cursor &#8211; The cursor object","<code class=\"docutils literal\"><span class=\"pre\">pgdb</span></code> &#8212; The DB-API Compliant Interface","Introduction","Module functions and constants","TypeCache &#8211; The internal cache for database types","Type &#8211; 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],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_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_regtyp:10,user:[14,29],valu:[10,14,16],version:[0,2,32],view:10,welcom:33,were:27,whether:14,within:14,wrapper:10,write:[8,13]}})