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","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":4,"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","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"]]},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,6,8,9],"00642a46d":5,"008035450":5,"01":[5,9],"02":5,"03":5,"04":5,"04b6559f8":5,"05":[5,9],"059eda05f":5,"06":[5,9],"07":[5,9],"08":[5,9],"09":5,"0a0e1af80":5,"0a6858847":5,"0b0e4f7a4":5,"0b2":5,"0beta1":5,"0dbd0f420":5,"1":6,"10":5,"10097":5,"10205":5,"10483":5,"10528":5,"10543":5,"10818":5,"10864":5,"11":[5,8,9],"11019":5,"11238":5,"11242":5,"11249":5,"11447":5,"11448":5,"11487":5,"11555":5,"11688":5,"11826":5,"11855":5,"12":[5,8,9],"12082":5,"12206":5,"12212":5,"12304":5,"12366":5,"12390":5,"12444":5,"12449":5,"12466":5,"12558":5,"12917":5,"12955":5,"12af6a080":5,"12c5e5d8a":5,"13":5,"13148":5,"13281":5,"13380":5,"13717":5,"13732":5,"13767":5,"14":5,"14013":5,"14734":5,"14886":5,"15":5,"15360":[5,7],"15393":5,"15412":[5,7],"15576":5,"15667":[5,7],"15699":5,"16":5,"16100":[5,7],"16294":5,"16405":5,"16464":5,"16501":5,"16521":[5,7],"16682":5,"16872":5,"16e712971":5,"17":5,"17015":5,"17020":5,"17116":5,"17214":5,"17331":5,"17423":[5,7],"17682":5,"17890":5,"18":5,"18027":[5,7],"18236":[5,7],"18597":5,"18613":5,"18855":5,"19":5,"19321":5,"19489":[5,7],"19599":5,"19725":5,"19791":5,"19815":[5,7],"19827":[5,7],"19882":5,"1d36b0303":5,"1fba5402b":5,"2":[0,1,2,3,4,6,8,9],"20":5,"2013":9,"2018":9,"2019":9,"20190":5,"2020":[5,9],"2021":[5,8],"2022":5,"2037303ee":5,"20523":5,"20565":5,"20571":5,"20600":5,"20608":5,"20614":5,"20951":5,"21":5,"21205":[5,7],"21237":[5,7],"21257":5,"21403":[5,7],"22":5,"23":[5,9],"23rc1":5,"24":5,"25":5,"26":5,"27":5,"28":5,"29":5,"295d66f91":5,"2a1":5,"2fclient":6,"2fserver":6,"2ftmp":6,"3":[0,1,2,3,4,6,8,9],"30":5,"300":1,"31":[5,9],"32971a1a2":5,"349b0811c":5,"355dec8f":5,"3696c34c2":5,"375d1ca22":5,"37681bca0":5,"39e395f98":5,"3cddc1182":5,"3ee916e9":5,"3fd5ef355":5,"406f":8,"4734":5,"49":8,"4bde99f13":5,"4be04143a":5,"4d3a":8,"4e8f9cc8d":5,"512":8,"5220e4c38":5,"54":8,"5432":6,"59eb5de78":5,"5a439e84":5,"5b2fe0e74":5,"5c6e":8,"6":5,"602abe839":5,"6610":5,"6655":5,"6674":8,"6714":5,"6792":5,"6822":5,"6889a333c":5,"68d1714f2":5,"68e4c4dcb":5,"6c3a67d4f":5,"6cf76d7ac":5,"6e6526a0f":5,"7":7,"70c74c1f6":5,"7231":5,"7271":5,"7338":5,"7412":5,"7541":5,"76ed2a49c":5,"778be7993":5,"7802":5,"7825e8f59":5,"8":5,"807ad32c":5,"81ebd78db":5,"82c0e5aff":5,"83b51e530":5,"83f8e178b":5,"840ea3efb":5,"853576d90":5,"85a18e13d":5,"8625":5,"866a601b7":5,"86a2a19ad":5,"872b1566a":5,"87f408b1e":5,"8807":5,"8886":5,"8891":5,"8898":5,"88bdcfa0d":5,"8984":5,"8994":5,"8b1":5,"8c42cf1b0":5,"8ec4":8,"8f81b9a01":5,"9026":5,"92585ca4c":5,"9320":5,"9370":5,"9404":5,"9408":5,"9549274d1":5,"9550":5,"97496ba2b":5,"97a429f9d":5,"9b39f2478":5,"9c75ea3c1":5,"9c8391a13":5,"9c94b72d4":5,"9cbd7de6d":5,"class":[5,7,9],"default":[1,4,5,6],"do":[5,7,8],"export":6,"final":[5,9],"function":5,"import":[5,7,8,9],"new":[5,7],"null":9,"public":1,"return":[1,7],"static":5,"switch":5,"true":[1,4],"try":[5,7],A:9,AND:9,And:9,By:8,For:[1,5,6,7,8],IF:9,INTO:9,If:[1,7,8],In:9,It:[1,8,9],NOT:9,The:[1,4,6,7,8],There:[6,8],These:9,To:[5,8,9],_hook:5,_oper:5,_sensor:5,a0821235f:5,a28c66f23:5,a4dc11fa:5,a9ac2b040:5,about:[5,8],abov:8,ac2f72c98:5,access:1,acycl:9,ad:[5,7],add:[5,7],adjust:5,ae7cb4a1:5,aeea71274:5,after:[5,6],aip:5,airflow:[8,9],airflow_conn_:6,airflow_conn_postgres_default:6,aka:8,all:[5,6,7,9],allow:6,alreadi:[8,9],also:[1,8],amazon:[5,7],an:[0,1,2,3,4,5,6,7,8,9],ani:[7,8],ann:9,annot:5,apach:[8,9],apache_airflow_providers_postgr:8,api:7,appeal:9,appli:[5,7],application_nam:6,apply_default:[5,7],ar:[4,6,7,8,9],arg:[1,5],asc:[7,8],attribut:[5,7,9],august:5,authent:1,author:6,auto:[5,7],autoapi:5,autocommit:4,autom:5,automat:[4,7],avail:[8,9],avoid:[5,7],aw:[1,5],awar:1,aws_conn_id:1,aws_default:1,awshook:1,b2a28d159:5,b40dffa08:5,b916b7507:5,ba4b:8,backport:5,base:[1,4,9],base_aw:5,baseoper:[4,9],bash:8,batch:5,bbc627a3d:5,bcf719bfb:5,be75dcd39:5,begin:1,begin_d:9,belong:8,below:[8,9],best:9,between:9,bin:8,binari:[7,8],birth_dat:9,black:5,bool:4,both:9,boto3:5,broken:5,bst:8,buggfix:5,build:[5,8],built:5,bulk_dump:1,bulk_load:1,c34ef853c:5,c7e5bce57:5,c84b435cc:5,c97a2e8ab:5,ca4238eb4:5,ca:6,cach:5,call:[1,9],can:[1,6,7,8,9],candid:5,carri:9,cat:9,catchup:9,cbf8001d7:5,cde15c6e4d3a8ec4ecf4ba4b6674e08ad7de406f:8,cde1:8,cdec30125:5,cert:[1,6],certif:[6,8],certifi:8,chang:5,changelog:5,chapter:8,charact:[5,6],check:[1,5,7,8],checksum:[7,8],choos:[1,8],cleanup:5,client:[5,6],client_encod:[5,6,7],cluster:[1,5,7],code:[4,8,9],column:1,com:8,come:5,command:[1,4,5],comment:5,commit:[4,5],compat:5,complet:7,compon:6,condit:[5,7],conn:[1,4],conn_id:6,conn_name_attr:1,conn_typ:1,connect:[1,4,5,7],constructor:5,contain:[6,8,9],context:[4,5],control:6,copi:1,copy_expert:1,correct:[5,8],coverag:5,creat:[1,4,8],create_pet_t:9,crl:6,cross:5,curl:8,cursor:1,cursortyp:1,d02ded65:5,d0e7db402:5,d200:5,d305876be:5,d56e7b56b:5,d58df468c:5,d7de:8,d9567eb10:5,d99afc3c2:5,d:8,dad2f8103:5,dag:[5,7],dag_id:9,data:[1,5],databas:[1,4,6],date:9,datetim:9,db:[6,7],dbapi:1,dbapihook:[1,5,7],decemb:5,decor:[5,7],deepcopi:[5,7],default_arg:5,default_conn_nam:1,defin:[4,9],deleg:9,delimit:1,dep:8,depend:[5,9],deprec:[5,7],deriv:4,describ:8,descript:5,dest:8,detail:[1,5,6,7,8],determin:6,dev0:[0,1,2,3,4,5,6,7,8,9],dev:5,dict:5,dictcursor:1,dictionari:[4,6],diff:8,differ:[8,9],direct:9,directli:9,directori:[8,9],disabl:6,discoveri:5,distribut:8,doc:5,document:[5,6,7],doe:1,dog:9,down:[8,9],download:8,drop:8,due:7,dump:[1,9],dure:9,dynam:[5,9],e07139ab7:5,e08a:8,e0a41971a:5,each:[1,4],ecf4:8,echo:8,eded:4,edg:9,ee7ca128a:5,ef037e702:5,eff1525d1:5,eleg:9,empti:1,enabl:5,encod:6,end:4,end_dat:9,error:5,escap:5,essenti:[8,9],establish:1,etc:1,even:5,eventu:9,everyth:9,everywher:5,exampl:[1,5,6,7,8,9],example_dag:9,example_postgr:9,execut:[1,4],exist:[1,7,9],experiment:[0,1,2,3,4,5,6,7,8,9],explor:9,ext:5,extra:[1,5,6,7],extract:1,f3521fb0e:5,f6bd817a3:5,f77417eb0:5,f:5,fals:[4,9],fc845caf7:5,fdd9b6f65:5,featur:[0,1,2,3,4,5,6,8,9],fed:9,field:[1,5,6,7],file:[1,4,5,6,7,8,9],filenam:1,find:9,fingerprint:8,first:7,fix:5,flynt:5,folder:[8,9],follow:[6,8],form:5,formmatt:5,forward:[5,7],found:6,foundat:8,free:9,fresh:5,friendli:5,from:[1,5,7],full:6,gener:5,get:[1,5,8,9],get_all_pet:9,get_birth_d:9,get_conn:1,get_iam_token:1,get_table_primary_kei:1,get_template_context:4,get_uri:[1,7],gmail:8,good:8,gpg:8,grammar:5,graph:9,guid:[5,8],gz:8,ha:9,hamster:9,hash:5,have:[1,5,7,9],heavi:9,helper:1,high:5,highlight:9,hood:9,hook:[2,5],hook_nam:1,host:[1,6],how:[5,8],howev:1,howto:7,http:8,i:8,iam:1,id:[1,4,8],identifi:[1,5,7],implement:[5,9],improv:5,inact:6,includ:5,increas:5,indic:8,individu:5,inform:5,inherit:9,initi:7,inject:9,input:1,insert_row:5,insid:9,instal:5,instanc:[5,7],instanti:9,instead:[7,9],instruct:8,integr:5,interact:[1,9],interest:9,introduc:5,involv:9,ip:6,isn:9,issuer:8,iter:4,its:[1,9],jane:9,januari:5,jinja:4,json:6,juli:5,june:5,k8:5,ka:8,kaxil:8,kaxilnaik:8,keepal:6,keepalives_idl:[1,6],kei:[1,6,8,9],know:8,kwarg:[1,4],l:8,la:8,languag:5,latest:5,lazili:5,least:7,leav:1,left:8,less:1,lester:9,let:9,level:5,lexer:[5,7],lift:9,like:9,lili:9,line:5,link:[5,8],list:[1,4,5,6,7],load:1,local:8,log:5,login:6,logo:5,look:9,ls:8,made:[8,9],magic:5,main:[4,8],maintain:9,make:[5,7,9],manag:[5,8],mani:9,manual:7,map:4,markdown:5,match:[5,8],max:9,messag:6,meta:5,method:[1,4,5,7],might:7,migrat:7,mirror:8,misc:5,miscellan:5,miss:5,mktemp:8,mode:6,model:4,modul:5,month:5,more:[1,4,5,6,7,9],most:8,move:5,mutat:[5,7],my_aws_conn:1,my_cluster_id:1,mypi:5,naik:8,name:[1,4,5,6,9],necessari:1,need:7,negoti:6,node:9,none:[1,4,5,8],note:[1,5,6],novemb:5,now:[5,9],number:[5,6],o:8,obj:[5,7],object:9,octob:5,offer:9,offici:8,onc:[8,9],one:[4,8],onli:7,oper:[1,2,5,7],optimis:7,option:[1,4,6],order:7,org:8,origin:8,otherwis:7,our:[5,9],out:[5,6,9],overrid:1,overridden:1,overwrit:4,owner:[8,9],packag:9,package_nam:8,package_vers:8,page:[5,8],pain:9,param:[5,9],paramat:5,paramet:[1,4,5,6],parent:9,parrot:9,pass:[5,6,7],password:[1,6],path:1,pattern:5,pem:[1,6],per:5,pet:9,pet_id:9,pet_schema:9,pet_typ:9,pgp:8,pgpk:8,pgpv:8,phil:9,pip:[5,8],pipelin:9,pleas:8,point:5,popul:9,popular:5,populate_pet_t:9,port:1,possibl:9,postgr:[6,8],postgreoper:9,postgres_conn_id:[1,4,9],postgres_default:[1,4,9],postgres_hook_aws_conn_id:[5,7],postgres_operator_dag:9,postgres_us:6,postgresdb:6,postgreshook:[1,5,7,9],postgresoper:[4,5,7],postgresql:[5,7,9],practic:9,prefer:6,prefix:7,prepar:5,prevent:9,previou:8,primari:[1,8,9],prioriti:6,privat:[5,7],project:5,provid:[6,8,9],provider_download_dir:8,psycopg2:[1,5,7],purpos:9,put:9,py3:8,py:9,pydocstyl:5,pylint:5,pypi:[5,7],python:[5,6,7,8],pyupgrad:5,queri:[4,9],quickli:9,quinci:9,quit:9,rc2:5,rc3:5,readm:[5,7],recogn:4,recommend:8,redshift:1,redund:5,ref:5,refactor:[5,9],refer:[1,4,5,6],refernc:5,reflect:7,regener:5,relas:5,releas:[5,7],relev:8,rema:5,remain:5,remov:[5,7,8],renam:5,render:[4,5,7],replac:[5,6,7],repositori:7,request:9,requir:[1,6,9],resid:9,retriev:1,revert:5,revoc:6,road:9,robust:9,rsa:8,run:[7,8],runtim:9,s3toredshift:[5,7],s:[5,6,8,9],sai:9,same:4,sat:8,schedule_interv:9,schema:[1,5,6,7],script:[5,8],sdist:[7,8],second:[1,5,6,7],secur:6,see:5,select:[8,9],self:[1,4,8],send:6,sensor:5,sep:8,separ:5,septemb:5,sequenc:[4,5],serial:9,server:[6,8],servic:1,set:[1,6],setup:5,sha512:[7,8],sha:8,shasum:8,should:[5,6,7,8,9],sign:8,signatur:[5,7,8],simpl:9,simplehttpoper:5,simpli:9,singl:4,site:7,six:6,snippet:9,so:1,softwar:[5,8],solut:9,somewher:9,sourc:[1,4,7,9],specif:[1,4],specifi:[1,6,7],spell:5,sphinx:5,sql:[1,4,5,7,9],sqlalchemi:7,ssl:[1,6],sslca:6,sslcert:[1,6],sslcrl:6,sslkei:6,sslmode:[1,6],sslrootcert:6,standard:6,start_dat:[5,9],statement:[1,4,9],step:8,store:9,str:[1,4],string:[4,5],subdirectori:9,subject:5,succe:1,sum:8,superus:1,support:[5,6,7],supports_autocommit:1,susi:9,symmetr:9,synchron:5,syntax:6,t:9,tab:1,tabl:1,takeawai:9,tar:8,target:1,task:9,task_id:9,tcp:6,templat:[4,5,7],template_ext:4,template_field:[4,5],template_fields_rend:5,template_fields_render:[4,5,7],temporari:[1,8],test:5,than:1,thei:1,them:7,themselv:1,thi:[0,1,2,3,4,5,6,7,8,9],thing:9,those:[7,8],tidi:9,time:9,tmp:6,tmp_file:1,toc:5,togeth:9,token:1,tool:5,toolchain:5,top:[7,8],transfer:5,trove:9,trust:8,two:9,type:[1,5,6,7],typehint:5,typo:5,ui_color:4,under:9,union:4,unit:9,unknown:8,unless:1,up:[5,9],updat:[5,7],upgrad:[5,7],upsert:[5,7],uri:[1,6,7],url:6,us:[1,4,5,6,7,8,9],usag:[5,7],user:[1,6,8],utf:5,valid:8,valu:[4,6,9],varchar:9,variabl:6,variou:9,verifi:[6,7],version:[5,7,8],via:[7,8],virtu:9,wai:9,want:[1,7,8],warn:[5,8],wave:5,we:9,well:8,what:6,wheel:7,when:[1,4,6,7,9],where:[6,7,9],whether:6,which:[4,6,7,9],whl:8,why:8,without:1,word:5,work:9,workflow:9,worri:8,wrong:5,wrongli:5,xxxxxxxxxxxx:6,you:[1,6,7,8,9],your:[1,7]},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>","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":[5,7],"1":[5,7],"2":[5,7],"3":[5,7],"4":[5,7],"break":7,"class":[1,4],The:9,airflow:[0,1,2,3,4,5,7],apach:[5,7],attribut:1,bug:7,chang:7,changelog:7,commit:7,common:9,complet:9,conclus:9,configur:6,connect:6,content:[1,4,7],creat:9,cross:7,dag:9,data:9,databas:9,depend:7,download:7,featur:7,fetch:9,fix:7,from:[8,9],guid:[7,9],hook:[0,1],how:9,insert:9,instal:[7,8],integr:8,introduct:9,misc:7,modul:[1,4],offici:7,oper:[3,4,9],packag:[5,7,8],paramet:9,pass:9,pip:7,postgr:[0,1,2,3,4,5,7,9],postgresoper:9,postgresql:6,provid:[0,1,2,3,4,5,7],pypi:8,record:9,refer:7,releas:8,requir:7,resourc:7,sourc:8,submodul:[0,3],subpackag:2,tabl:9,verifi:8,your:9}})