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":3,"sphinx.domains.index":1,"sphinx.domains.javascript":2,"sphinx.domains.math":2,"sphinx.domains.python":2,"sphinx.domains.rst":2,"sphinx.domains.std":1,"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":{postgres:[2,0,0,"-"]},"airflow.providers.postgres":{hooks:[0,0,0,"-"],operators:[3,0,0,"-"]},"airflow.providers.postgres.hooks":{postgres:[1,0,0,"-"]},"airflow.providers.postgres.hooks.postgres":{CursorType:[1,1,1,""],PostgresHook:[1,2,1,""]},"airflow.providers.postgres.hooks.postgres.PostgresHook":{bulk_dump:[1,3,1,""],bulk_load:[1,3,1,""],conn_name_attr:[1,4,1,""],conn_type:[1,4,1,""],copy_expert:[1,3,1,""],default_conn_name:[1,4,1,""],get_conn:[1,3,1,""],get_iam_token:[1,3,1,""],get_table_primary_key:[1,3,1,""],hook_name:[1,4,1,""],supports_autocommit:[1,4,1,""]},"airflow.providers.postgres.operators":{postgres:[4,0,0,"-"]},"airflow.providers.postgres.operators.postgres":{PostgresOperator:[4,2,1,""]},"airflow.providers.postgres.operators.postgres.PostgresOperator":{execute:[4,3,1,""],template_ext:[4,4,1,""],template_fields:[4,4,1,""],template_fields_renderers:[4,4,1,""],ui_color:[4,4,1,""]}},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:{"00642a46d":5,"008035450":5,"04b6559f8":5,"059eda05f":5,"0a0e1af80":5,"0a6858847":5,"0b0e4f7a4":5,"0b2":5,"0beta1":5,"0dbd0f420":5,"10097":5,"10205":5,"10483":5,"10528":5,"10543":5,"10818":5,"10864":5,"11019":5,"11238":5,"11242":5,"11249":5,"11447":5,"11448":5,"11487":5,"11555":5,"11688":5,"11826":5,"11855":5,"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,"13148":5,"13281":5,"13380":5,"13717":5,"13732":5,"13767":5,"14013":5,"14734":5,"14886":5,"15360":[5,7],"15393":5,"15412":[5,7],"15576":5,"15667":[5,7],"15699":5,"16100":[5,7],"16294":5,"16405":5,"16464":5,"16501":5,"16521":[5,7],"16682":5,"16872":5,"16e712971":5,"17015":5,"17020":5,"17116":5,"17214":5,"17331":5,"17423":[5,7],"17682":5,"17890":5,"18027":[5,7],"18236":[5,7],"18597":5,"1d36b0303":5,"1fba5402b":5,"2013":9,"2018":9,"2019":9,"2020":[5,9],"2021":[5,8],"2037303ee":5,"23rc1":5,"295d66f91":5,"2a1":5,"2fclient":6,"2fserver":6,"2ftmp":6,"300":1,"32971a1a2":5,"349b0811c":5,"3696c34c2":5,"375d1ca22":5,"37681bca0":5,"3cddc1182":5,"3ee916e9":5,"3fd5ef355":5,"406f":8,"4734":5,"4bde99f13":5,"4d3a":8,"4e8f9cc8d":5,"512":8,"5220e4c38":5,"5432":6,"59eb5de78":5,"5a439e84":5,"5b2fe0e74":5,"5c6e":8,"6610":5,"6655":5,"6674":8,"6714":5,"6792":5,"6822":5,"6889a333c":5,"68d1714f2":5,"68e4c4dcb":5,"6cf76d7ac":5,"6e6526a0f":5,"70c74c1f6":5,"7231":5,"7271":5,"7338":5,"7412":5,"7541":5,"76ed2a49c":5,"778be7993":5,"7802":5,"7825e8f59":5,"807ad32c":5,"81ebd78db":5,"82c0e5aff":5,"85a18e13d":5,"8625":5,"866a601b7":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,"9026":5,"92585ca4c":5,"9320":5,"9370":5,"9404":5,"9408":5,"9549274d1":5,"9550":5,"97a429f9d":5,"9b39f2478":5,"9c75ea3c1":5,"9c8391a13":5,"9c94b72d4":5,"9cbd7de6d":5,"class":[1,4,5,7,9],"default":[1,4,5,6],"export":6,"final":[5,9],"function":5,"import":[5,7,8,9],"new":5,"null":9,"public":1,"return":1,"static":5,"switch":5,"true":[1,4],AND:9,AWS:[1,5],Added:[5,7],And:9,For:[1,5,6,7,8],INTO:9,NOT:9,The:[1,4,6,7,8],There:[6,8],These:9,Use:5,Uses:1,_hook:5,_oper:5,_sensor:5,a28c66f23:5,a4dc11fa:5,a9ac2b040:5,about:[5,8],abov:8,ac2f72c98:5,access:1,acycl:9,add:[5,7],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],ani: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],arg:[1,5],asc:[7,8],attribut:[5,7,9],august:5,authent:1,author:6,auto:[5,7],autocommit:4,autom:5,automat:[4,7],avail:[8,9],avoid:[5,7],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],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],bulk_dump:1,bulk_load:1,c34ef853c:5,c7e5bce57:5,ca4238eb4:5,cach:5,call:[1,9],can:[1,4,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,check:[1,5,8],checksum:[7,8],choos:[1,8],cleanup:5,client:[5,6],cluster:[1,5,7],code:[4,8,9],column:1,com:8,come:5,command:[1,4,5],comment:5,commit:[4,5,7],compat:5,complet:7,compon:6,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,control:6,copi:1,copy_expert:1,correct:[5,8],coverag:5,creat:[1,8],create_pet_t:9,crl:6,cross:5,curl:8,cursor:1,cursortyp:1,d02ded65:5,d0e7db402:5,d200:5,d305876be:5,d7de:8,d99afc3c2:5,dag:[5,7],dag_id:9,data:[1,5],databas:[1,4,6],date:9,datetim:9,dbapi:1,dbapihook:[1,5,7],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],describ:8,descript:5,dest:8,detail:[1,5,6,7,8],determin:6,dev:5,dict:[4,5],dictcursor:1,dictionari: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],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,escap:5,essenti:[8,9],establish:1,etc:1,eventu:9,everyth:9,exampl:[1,5,6,7,8,9],example_dag:9,example_postgr:9,execut:[1,4],exist:[1,7,9],explor:9,extra:[1,5,6,7],extract:1,f3521fb0e:5,f6bd817a3:5,fals:[4,9],fc845caf7:5,fdd9b6f65:5,featur:5,fed:9,field:[1,5,6],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,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,gmail:8,good:8,gpg:8,grammar:5,graph:9,guid:[5,7,8],hamster:9,has:9,hash:5,have:[1,7,9],heavi:9,helper:1,high:5,highlight:9,hood:9,hook:[2,5,9],hook_nam:1,host:[1,6],how:[5,8],howev:1,howto:7,http:8,iam:1,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:9,instruct:8,integr:5,interact:[1,9],interest:9,introduc:5,involv:9,isn:9,issuer:8,iter:4,its:[1,9],jane:9,json:6,juli:5,june:5,kaxil:8,kaxilnaik:8,keepal:6,keepalives_idl:[1,6],kei:[1,6,8,9],know:8,kwarg:[1,4],latest:5,lazili:5,least:7,leav:1,left:8,less:1,lester:9,let:9,level:5,lift:9,like:9,lili:9,link:[5,8],list:[1,4,5,6,7],load:1,local:8,log:5,login:6,logo:5,look:9,made:[8,9],magic:5,main: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,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,5,6,9],most:8,move:5,mutat:[5,7],my_aws_conn:1,my_cluster_id:1,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],now:9,number:[5,6],obj:[5,7],object:9,octob:5,offer:9,offici:8,onc:[8,9],one:[4,8],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],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,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,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],receiv:4,recogn:4,recommend:8,redshift:1,redund:5,ref:5,refactor:[5,9],refer:[1,4,5,7],refernc:5,regener:5,relas:5,releas:[5,7],relev:8,rema:5,remain:5,remov:[5,7,8],renam:5,render:4,replac:6,repositori:7,repres:4,request:9,requir:[1,6,9],resid:9,resourc:7,retriev:1,revoc:6,road:9,robust:9,rsa:8,run:[7,8],runtim:9,s3toredshift:[5,7],sai:9,sat:8,schedule_interv:9,schema:[1,5,6,7],script:[5,8],sdist:[7,8],second:[1,6],secur:6,see:5,select:[8,9],self:[1,4,8],send:6,sensor:5,sep:8,separ:5,serial:9,server:[6,8],servic:1,set:1,setup:5,sha512:[7,8],sha:8,shasum:8,should:[5,6,8,9],sign:8,signatur:[5,7,8],simpl:9,simplehttpoper:5,simpli:9,site:7,six:6,snippet:9,softwar:[5,8],solut:9,somewher:9,sourc:[1,4,7,9],specif:[1,4],specifi:[1,6,7],spell:5,sql:[1,4,5,9],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:5,subdirectori:9,subject:5,succe:1,sum:8,superus:1,support:[5,6],supports_autocommit:1,susi:9,symmetr:9,synchron:5,syntax:6,tab:1,tabl:1,takeawai:9,tar:8,target:1,task:9,task_id:9,tcp:6,templat:4,template_ext:4,template_field:4,template_fields_rend:5,template_fields_render:4,temporari:[1,8],test:5,than:1,thei:1,them:7,themselv:1,thi:[1,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],typo:5,ui_color:4,under:9,union:4,unit:9,unknown:8,unless:1,updat:[5,7],upgrad:[5,7],upsert:[5,7],uri:6,url:6,use:[1,5,7,8,9],used:[1,6,8,9],user:[1,6,8],using:[1,5,8,9],utf:5,valid:8,valu:[4,6,9],varchar:9,variabl:6,variou:9,verifi:[6,7],version:[5,7,8],via:[7,8],view:9,virtu:9,wai:9,want:[1,7,8],warn:[5,8],wave:5,well:8,what:6,wheel:7,when:[1,6,7,9],where:[6,9],whether:6,which:[4,6,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:{"break":7,The:9,airflow:[0,1,2,3,4,5,7],apach:[5,7],bug:7,chang:7,changelog: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: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,releas:8,requir:7,sourc:8,submodul:[0,3],subpackag:2,tabl:9,verifi:8,your:9}})