Search.setIndex({docnames:["_api/airflow/providers/postgres/hooks/index","_api/airflow/providers/postgres/hooks/postgres/index","_api/airflow/providers/postgres/index","_api/airflow/providers/postgres/operators/index","_api/airflow/providers/postgres/operators/postgres/index","_api/tests/system/providers/postgres/example_postgres/index","_api/tests/system/providers/postgres/index","commits","connections/postgres","index","installing-providers-from-sources","operators/postgres_operator_howto_guide"],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.ext.intersphinx":1,"sphinx.ext.viewcode":1,sphinx:56},filenames:["_api/airflow/providers/postgres/hooks/index.rst","_api/airflow/providers/postgres/hooks/postgres/index.rst","_api/airflow/providers/postgres/index.rst","_api/airflow/providers/postgres/operators/index.rst","_api/airflow/providers/postgres/operators/postgres/index.rst","_api/tests/system/providers/postgres/example_postgres/index.rst","_api/tests/system/providers/postgres/index.rst","commits.rst","connections/postgres.rst","index.rst","installing-providers-from-sources.rst","operators/postgres_operator_howto_guide.rst"],objects:{"airflow.providers":[[2,0,0,"-","postgres"]],"airflow.providers.postgres":[[0,0,0,"-","hooks"],[3,0,0,"-","operators"]],"airflow.providers.postgres.hooks":[[1,0,0,"-","postgres"]],"airflow.providers.postgres.hooks.postgres":[[1,1,1,"","CursorType"],[1,2,1,"","PostgresHook"]],"airflow.providers.postgres.hooks.postgres.PostgresHook":[[1,3,1,"","bulk_dump"],[1,3,1,"","bulk_load"],[1,4,1,"","conn_name_attr"],[1,4,1,"","conn_type"],[1,3,1,"","copy_expert"],[1,4,1,"","default_conn_name"],[1,3,1,"","get_conn"],[1,3,1,"","get_iam_token"],[1,3,1,"","get_table_primary_key"],[1,3,1,"","get_uri"],[1,4,1,"","hook_name"],[1,4,1,"","supports_autocommit"]],"airflow.providers.postgres.operators":[[4,0,0,"-","postgres"]],"airflow.providers.postgres.operators.postgres":[[4,2,1,"","PostgresOperator"]],"airflow.providers.postgres.operators.postgres.PostgresOperator":[[4,3,1,"","execute"],[4,4,1,"","template_ext"],[4,4,1,"","template_fields"],[4,4,1,"","template_fields_renderers"],[4,4,1,"","ui_color"]],"tests.system.providers":[[6,0,0,"-","postgres"]],"tests.system.providers.postgres":[[5,0,0,"-","example_postgres"]],"tests.system.providers.postgres.example_postgres":[[5,1,1,"","DAG_ID"],[5,1,1,"","ENV_ID"],[5,1,1,"","create_pet_table"],[5,1,1,"","test_run"]]},objnames:{"0":["py","module","Python module"],"1":["py","data","Python data"],"2":["py","class","Python class"],"3":["py","method","Python method"],"4":["py","attribute","Python attribute"]},objtypes:{"0":"py:module","1":"py:data","2":"py:class","3":"py:method","4":"py:attribute"},terms:{"0":[0,1,2,3,4,5,6,8,10,11],"00642a46d0":7,"0080354502":7,"01":[7,11],"02":7,"027b707d21":7,"03":7,"04":7,"04b6559f8a":7,"05":[7,11],"059eda05f8":7,"06":[7,11],"07":[7,11],"08":[7,11],"09":7,"0a0e1af800":7,"0a68588479":7,"0b0e4f7a4c":7,"0b2":7,"0beta1":7,"0dbd0f420c":7,"0ec56775df":7,"1":8,"10":[7,9],"10097":7,"10205":7,"10483":7,"10528":7,"10543":7,"10818":7,"10864":7,"11":[7,10,11],"11019":7,"11238":7,"11242":7,"11249":7,"11447":7,"11448":7,"11487":7,"11555":7,"11688":7,"11826":7,"11855":7,"12":[7,10,11],"12082":7,"12206":7,"12212":7,"12304":7,"12366":7,"12390":7,"12444":7,"12449":7,"12466":7,"12558":7,"12917":7,"12955":7,"12af6a0800":7,"12c5e5d8a":7,"13":7,"13148":7,"13281":7,"13380":7,"13717":7,"13732":7,"13767":7,"14":7,"14013":7,"14734":7,"14886":7,"15":7,"15360":[7,9],"15393":7,"15412":[7,9],"15576":7,"15667":[7,9],"15699":7,"16":7,"16100":[7,9],"16294":7,"16405":7,"16464":7,"16501":7,"16521":[7,9],"16682":7,"16872":7,"16adc035b1":7,"16e7129719":7,"17":7,"17015":7,"17020":7,"17116":7,"17214":7,"17331":7,"17423":[7,9],"17682":7,"17890":7,"18":7,"18027":[7,9],"18236":[7,9],"18597":7,"18613":7,"18855":7,"19":7,"19321":7,"19489":[7,9],"19599":7,"19725":7,"19791":7,"19815":[7,9],"19827":[7,9],"19882":7,"1d36b0303b":7,"1fba5402bb":7,"2":[0,1,2,3,4,5,6,8,10,11],"20":7,"2013":11,"2018":11,"2019":11,"20190":7,"2020":[7,11],"2021":[7,10],"2022":7,"2037303eef":7,"20523":7,"20565":7,"20571":7,"20600":7,"20608":7,"20614":7,"20951":7,"21":7,"21205":[7,9],"21237":[7,9],"21257":7,"21403":[7,9],"21439":7,"21551":[7,9],"21764":[7,9],"22":7,"22056":7,"22226":7,"22382":9,"22383":7,"22458":7,"23":[7,11],"23rc1":7,"24":7,"24148":7,"24229":7,"24231":7,"24292":7,"25":7,"26":7,"27":7,"28":7,"29":7,"295d66f914":7,"2a1":7,"2fclient":8,"2fserver":8,"2ftmp":8,"30":7,"300":1,"3000m":11,"31":[7,11],"32971a1a2d":7,"349b0811c3":7,"355dec8fea":7,"3696c34c28":7,"375d1ca229":7,"37681bca00":7,"39e395f981":7,"3cddc11821":7,"3ee916e9e1":7,"3fd5ef3555":7,"4":[0,1,2,3,4,5,6,8,10,11],"406f":10,"4734":7,"49":10,"4bde99f132":7,"4be04143a5":7,"4d3a":10,"4e8f9cc8d0":7,"5":[0,1,2,3,4,5,6,8,10,11],"512":10,"5220e4c384":7,"54":10,"5432":8,"59c450ee54":7,"59eb5de78c":7,"5a439e84eb":7,"5b2fe0e740":7,"5c6e":10,"6":7,"602abe8394":7,"6610":7,"6655":7,"6674":10,"6714":7,"6792":7,"6822":7,"6889a333cf":7,"68d1714f29":7,"68e4c4dcb0":7,"6c3a67d4fc":7,"6cf76d7ac0":7,"6e6526a0f6":7,"7":9,"70c74c1f68":7,"717a7588bc":7,"7231":7,"7271":7,"7338":7,"7412":7,"7541":7,"76ed2a49c6":7,"778be7993d":7,"7802":7,"7825e8f590":7,"8":7,"807ad32ce5":7,"81ebd78db4":7,"82c0e5aff6":7,"83b51e5306":7,"83f8e178ba":7,"840ea3efb9":7,"853576d901":7,"85a18e13d9":7,"8625":7,"866a601b76":7,"86a2a19ad2":7,"872b1566a1":7,"87f408b1e7":7,"8807":7,"8886":7,"8891":7,"8898":7,"88bdcfa0df":7,"8984":7,"8994":7,"8b1":7,"8c42cf1b00":7,"8ec4":10,"8f81b9a01c":7,"9026":7,"92585ca4cb":7,"9320":7,"9370":7,"9404":7,"9408":7,"9549274d11":7,"9550":7,"97496ba2b4":7,"97a429f9d0":7,"9b39f24780":7,"9c75ea3c14":7,"9c8391a13f":7,"9c94b72d44":7,"9cbd7de6d1":7,"class":[7,9,11],"default":[1,4,7,8],"do":[7,9,10],"export":8,"final":[7,11],"function":7,"import":[7,9,10],"new":[7,9],"null":11,"public":1,"return":[1,9],"static":7,"switch":7,"true":[1,4],"try":[7,9],A:11,AND:11,And:11,By:10,For:[1,7,8,9,10],IF:11,INTO:11,If:[1,9,10],In:11,It:[1,10,11],NOT:11,The:[1,4,8,9,10],There:[8,10],These:11,To:[7,10,11],_hook:7,_oper:7,_sensor:7,a0821235fb:7,a28c66f23d:7,a4dc11fae6:7,a9ac2b040b:7,abil:[7,9],about:[7,10],abov:10,ac2f72c98d:7,access:1,acycl:11,ad:[7,9],add:[7,9],adjust:7,ae7cb4a1e2:7,aeabe994b3:7,aeea71274d:7,after:[7,8],aip:7,airflow:[10,11],airflow_conn_:8,airflow_conn_postgres_default:8,aka:10,all:[7,8,9,11],allow:8,alreadi:[10,11],also:[1,10],amazon:[7,9],an:[0,1,2,3,4,5,6,7,8,9,10,11],ani:[9,10],ann:11,annot:7,apach:[10,11],apache_airflow_providers_postgr:10,api:9,appeal:11,appli:[7,9],application_nam:8,apply_default:[7,9],ar:[4,8,9,10,11],arg:[1,7],asc:[9,10],attribut:[7,9,11],august:7,authent:1,author:8,auto:[7,9],autoapi:7,autocommit:4,autom:7,automat:[4,9],avail:[9,10,11],avoid:[7,9],aw:[1,7],awar:1,aws_conn_id:1,aws_default:1,awshook:1,b2a28d1590:7,b40dffa085:7,b916b75079:7,ba4b:10,backport:7,base:[1,4,11],base_aw:7,baseoper:[4,11],bash:10,batch:7,bbc627a3da:7,bcf719bfb4:7,be75dcd39c:7,begin:1,begin_d:11,belong:10,below:[9,10,11],best:11,between:11,bin:10,binari:[9,10],birth_dat:11,black:7,blob:9,bool:4,both:11,boto3:7,broken:7,bst:10,bugfix:7,buggfix:7,build:[7,10],built:7,bulk_dump:1,bulk_load:1,c34ef853c8:7,c60bb9edc0:7,c7e5bce57f:7,c84b435cc9:7,c97a2e8ab8:7,ca4238eb4d:7,ca:8,cach:7,call:[1,11],can:[1,8,9,10,11],candid:7,carri:11,cat:11,catchup:11,cbf8001d76:7,cde15c6e4d3a8ec4ecf4ba4b6674e08ad7de406f:10,cde1:10,cdec301254:7,cert:[1,8],certif:[8,10],certifi:10,chang:7,changelog:7,chapter:10,charact:[7,8],check:[1,7,9,10],checksum:[9,10],choos:[1,10],classifi:[7,9],cleanup:7,client:[7,8],client_encod:[7,8,9],cluster:[1,7,9],code:[4,10,11],column:1,com:[9,10],come:7,command:[1,4,7],comment:7,commit:[4,7],compat:7,complet:9,compon:8,condit:[7,9],config:[7,9],conn:[1,4],conn_id:8,conn_name_attr:1,conn_typ:1,connect:[1,4,7,9],constructor:7,contain:[8,10,11],context:[4,7],contributor:7,control:[8,11],copi:1,copy_expert:1,correct:[7,10],coverag:7,creat:[1,4,10],create_pet_t:[5,11],crl:8,cross:7,curl:10,cursor:1,cursortyp:1,d02ded65ea:7,d0e7db4024:7,d200:7,d305876bee:7,d56e7b56bb:7,d58df468c8:7,d7dbfb7e26:7,d7de:10,d94fa37830:7,d9567eb106:7,d99afc3c21:7,d:10,dad2f8103b:7,dag:[7,9],dag_id:[5,11],data:[1,7],databas:[1,4,8],date:11,datetim:11,db:[8,9],dbapi:1,dbapihook:[1,7,9],decemb:7,decor:[7,9],deepcopi:[7,9],default_arg:7,default_conn_nam:1,defin:[4,11],delai:7,deleg:11,delimit:1,dep:10,depend:[7,11],deprec:[7,9],deriv:4,describ:10,descript:7,design:7,dest:10,detail:[1,7,8,9,10],determin:8,dev0:[0,1,2,3,4,5,6,7,8,9,10,11],dev:7,dict:7,dictcursor:1,dictionari:[4,8],diff:10,differ:[10,11],direct:11,directli:11,directori:[10,11],disabl:8,discoveri:7,distribut:10,doc:7,document:[7,8,9],doe:1,dog:11,doubl:7,down:[10,11],download:10,drop:10,due:9,dump:[1,11],dure:11,dynam:[7,11],e07139ab73:7,e08a:10,e0a41971a1:7,each:[1,4],ecf4:10,echo:10,eded:4,edg:11,ee7ca128a1:7,ef037e7021:7,eff1525d12:7,eleg:11,empti:1,enabl:7,encod:8,end:4,end_dat:11,env_id:[5,11],environ:11,error:7,escap:7,essenti:[10,11],establish:1,etc:1,even:7,eventu:11,everyth:11,everywher:7,exampl:[1,7,8,9,10,11],example_postgr:[6,11],execut:[1,4],exist:[1,9,11],experiment:[0,1,2,3,4,5,6,7,8,9,10,11],explain:9,explanatori:7,explor:11,ext:7,extra:[1,7,8,9],extract:1,f3521fb0e3:7,f5b96315fe:7,f6bd817a3a:7,f77417eb0d:7,f:7,fals:[4,11],fc845caf78:7,fdd9b6f65b:7,featur:[0,1,2,3,4,5,6,7,8,10,11],feb:7,fed:11,field:[1,7,8,9],file:[1,4,7,8,9,10,11],filenam:1,find:11,fingerprint:10,first:9,fix:7,flynt:7,folder:[10,11],follow:[8,10],form:7,formmatt:7,forward:[7,9],found:8,foundat:10,framework:9,free:11,fresh:7,friendli:7,from:[1,7,9],full:8,gener:7,get:[1,7,10,11],get_all_pet:11,get_birth_d:11,get_conn:1,get_iam_token:1,get_table_primary_kei:1,get_template_context:4,get_uri:[1,7,9],github:9,gmail:10,good:10,gpg:10,grammar:7,graph:11,guid:[7,10],gz:10,ha:11,hamster:11,hash:7,have:[1,7,9,11],heavi:11,helper:1,high:7,highlight:11,hood:11,hook:[2,7],hook_nam:1,host:[1,8],how:[7,10],howev:1,howto:9,http:[9,10],i:10,iam:1,id:[1,4,10],identifi:[1,7,9],implement:[7,11],improv:7,inact:8,includ:7,increas:7,indic:10,individu:7,inform:7,inherit:11,initi:9,inject:11,input:1,insert_row:7,insid:11,instal:7,install_requir:9,instanc:[7,9],instanti:11,instead:[9,11],instruct:10,integr:7,interact:[1,11],interest:11,introduc:7,involv:11,ip:8,isn:11,issuer:10,iter:4,its:[1,11],jane:11,januari:7,jinja:4,json:8,juli:7,june:7,k8:7,ka:10,kaxil:10,kaxilnaik:10,keepal:8,keepalives_idl:[1,8],kei:[1,8,10,11],know:10,kwarg:[1,4],l:10,la:10,languag:7,latest:7,lazili:7,least:9,leav:1,left:10,less:1,lester:11,let:11,level:7,lexer:[7,9],lift:11,like:11,lili:11,line:7,link:[7,10],list:[1,4,7,8,9],load:1,local:10,log:7,login:8,logo:7,look:11,ls:10,made:[10,11],magic:7,mai:7,main:[4,9,10],maintain:11,make:[7,9,11],manag:[7,10],mani:11,manual:9,map:4,march:7,markdown:7,match:[7,10],max:11,md:9,messag:8,meta:7,method:[1,4,7,9],might:9,migrat:[7,9],min:7,minimum:9,mirror:10,misc:7,miscellan:7,miss:7,mistakenli:9,mktemp:10,mode:8,model:4,modul:7,month:7,more:[1,4,7,8,9,11],most:10,move:7,mutat:[7,9],my_aws_conn:1,my_cluster_id:1,mypi:7,naik:10,name:[1,4,7,8,11],necessari:1,need:9,negoti:8,node:11,none:[1,4,7,10],note:[1,7,8],novemb:7,now:[7,11],number:[7,8],o:10,obj:[7,9],object:11,octob:7,offer:11,offici:10,onc:[10,11],one:[4,10],onli:9,oper:[1,2,7,9],optimis:9,option:[1,4,8,11],order:9,org:10,origin:10,os:11,otherwis:9,our:[7,11],out:[7,8,11],overrid:1,overridden:1,overwrit:4,owner:[10,11],packag:11,package_nam:10,package_vers:10,page:[7,10],pain:11,param:[7,9,11],paramat:7,paramet:[1,4,7,8],parent:11,parrot:11,pass:[7,8,9],password:[1,8],path:1,pattern:7,pem:[1,8],per:7,pet:11,pet_id:11,pet_schema:11,pet_typ:11,pgp:10,pgpk:10,pgpv:10,phil:11,pip:[7,9,10],pipelin:11,pleas:10,point:7,polici:9,popul:11,popular:7,populate_pet_t:11,port:1,possibl:11,postgr:[8,10],postgreoper:11,postgres_conn_id:[1,4,11],postgres_default:[1,4,11],postgres_hook_aws_conn_id:[7,9],postgres_operator_dag:[5,11],postgres_us:8,postgresdb:8,postgreshook:[1,7,9,11],postgresoper:[4,7,9],postgresql:[7,9,11],practic:11,prefer:8,prefix:9,prepar:7,prevent:11,previou:10,primari:[1,10,11],prioriti:8,privat:[7,9],project:7,provid:[8,10,11],provider_download_dir:10,psycopg2:[1,7,9],purpos:11,put:11,py3:10,py:11,pydocstyl:7,pylint:7,pypi:[7,9],python:[7,8,9,10],pyupgrad:7,queri:[4,11],quickli:11,quinci:11,quit:11,rc2:7,rc3:7,readm:[7,9],recogn:4,recommend:10,redshift:1,redund:7,ref:7,refactor:[7,11],refer:[1,4,7,8],refernc:7,reflect:9,regener:7,relas:7,releas:[7,9],relev:10,rema:7,remain:7,remov:[7,9,10],renam:7,render:[4,7,9],replac:[7,8,9],repositori:9,request:11,requir:[1,8,11],resid:11,retriev:1,revert:7,revoc:8,road:11,robust:11,rsa:10,run:[9,10],runtim:11,runtime_paramet:[4,11],s3toredshift:[7,9],s:[7,8,10,11],sai:11,same:4,sat:10,schedule_interv:11,schema:[1,7,8,9],script:[7,10],sdist:[9,10],second:[1,7,8,9],secur:8,see:[7,9],select:[10,11],self:[1,4,10],send:8,sensor:7,sep:10,separ:7,septemb:7,sequenc:[4,7],serial:11,server:[8,10],servic:1,set:[1,8,11],setup:7,sha512:[9,10],sha:10,shasum:10,should:[7,8,9,10,11],sign:10,signatur:[7,9,10],simpl:11,simplehttpoper:7,simpli:11,singl:4,site:9,six:8,snippet:11,so:1,softwar:[7,10],solut:11,somewher:11,sourc:[1,4,5,9,11],specif:[1,4,7],specifi:[1,8,9],spell:7,sphinx:7,sql:[1,4,7,9,11],sqlalchemi:9,ssl:[1,8],sslca:8,sslcert:[1,8],sslcrl:8,sslkei:8,sslmode:[1,8],sslrootcert:8,standard:8,start_dat:[7,11],statement:[1,4,11],statement_timeout:11,step:10,store:11,str:[1,4],string:[4,7],subdirectori:11,subject:7,succe:1,sum:10,superus:1,support:[7,8,9],supports_autocommit:1,susi:11,symmetr:11,synchron:7,syntax:8,system:11,system_tests_env_id:11,t:11,tab:1,tabl:1,takeawai:11,tar:10,target:1,task:11,task_id:11,tcp:8,templat:[4,7,9],template_ext:4,template_field:[4,7],template_fields_rend:7,template_fields_render:[4,7,9],temporari:[1,10],test:[7,11],test_run:5,than:1,thei:1,them:9,themselv:1,thi:[0,1,2,3,4,5,6,7,8,9,10,11],thing:11,those:[9,10],tidi:11,time:11,tmp:8,tmp_file:1,toc:7,togeth:11,token:1,tool:7,toolchain:7,top:[9,10],transfer:7,trove:[9,11],trust:10,two:11,type:[1,7,8,9],typehint:7,typo:7,ui_color:4,under:11,union:4,unit:11,unknown:10,unless:1,up:[7,11],updat:[7,9],upgrad:[7,9],upsert:[7,9],uri:[1,8,9],url:8,us:[1,4,7,8,9,10,11],usag:[7,9],user:[1,8,10],utf:7,valid:10,valu:[4,8,11],varchar:11,variabl:8,variou:11,verifi:[8,9],version:[7,9,10],via:[9,10],virtu:11,wai:11,want:[1,9,10],warn:[7,10],wave:7,we:11,well:10,what:8,wheel:9,when:[1,4,8,9,11],where:[8,9,11],whether:8,which:[4,8,9,11],whl:10,why:10,without:1,word:7,work:11,workflow:11,worri:10,wrong:7,wrongli:7,xxxxxxxxxxxx:8,you:[1,8,9,10,11],your:[1,9]},titles:["<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.hooks</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.hooks.postgres</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.operators</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.operators.postgres</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.postgres.example_postgres</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.postgres</span></code>","Package apache-airflow-providers-postgres","PostgreSQL Connection","<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-postgres</span></code>","Installing from sources","How-to Guide for PostgresOperator"],titleterms:{"0":[7,9],"1":[7,9],"2":[7,9],"3":[7,9],"4":[7,9],"5":[7,9],"break":9,"class":[1,4],The:11,airflow:[0,1,2,3,4,7,9],apach:[7,9],attribut:1,bug:9,chang:9,changelog:9,commit:9,common:11,complet:11,conclus:11,configur:[8,11],connect:8,content:[1,4,5,9],creat:11,cross:9,dag:11,data:11,databas:11,depend:9,download:9,example_postgr:5,featur:9,fetch:11,fix:9,from:[10,11],guid:[9,11],hook:[0,1],how:11,insert:11,instal:[9,10],integr:10,introduct:11,misc:9,modul:[1,4,5],offici:9,oper:[3,4,11],packag:[7,9,10],paramet:11,pass:11,postgr:[0,1,2,3,4,5,6,7,9,11],postgresoper:11,postgresql:8,provid:[0,1,2,3,4,5,6,7,9],pypi:10,record:11,refer:9,releas:10,requir:9,resourc:9,server:11,sourc:10,submodul:[0,3,6],subpackag:2,system:[5,6],tabl:11,test:[5,6],verifi:10,your:11}})