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","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","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":{_generate_insert_sql:[1,3,1,""],_get_cursor:[1,3,1,""],_serialize_cell:[1,3,1,""],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,""],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,"059eda05f":5,"0a0e1af80":5,"0b0e4f7a4":5,"0b2":5,"0beta1":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,"16e712971":5,"1d36b0303":5,"2013":8,"2018":8,"2019":8,"2020":[5,7,8],"2021":5,"2037303ee":5,"23rc1":5,"295d66f91":5,"2a1":5,"2fclient":6,"2fserver":6,"2ftmp":6,"300":1,"32971a1a2":5,"349b0811c":5,"3696c34c2":5,"375d1ca22":5,"3cddc1182":5,"3fd5ef355":5,"4734":5,"4bde99f13":5,"4e8f9cc8d":5,"5220e4c38":5,"5432":6,"59eb5de78":5,"5a439e84":5,"6610":5,"6655":5,"6714":5,"6792":5,"6822":5,"6889a333c":5,"68d1714f2":5,"6cf76d7ac":5,"7231":5,"7271":5,"7338":5,"7412":5,"7541":5,"7802":5,"7825e8f59":5,"82c0e5aff":5,"85a18e13d":5,"8625":5,"872b1566a":5,"8807":5,"8886":5,"8891":5,"8898":5,"8984":5,"8994":5,"8b1":5,"8c42cf1b0":5,"9026":5,"92585ca4c":5,"9320":5,"9370":5,"9404":5,"9408":5,"9549274d1":5,"9550":5,"97a429f9d":5,"9b39f2478":5,"9c75ea3c1":5,"9cbd7de6d":5,"case":7,"class":[1,4,5,7,8],"default":[1,4,5,6],"export":6,"final":[5,8],"function":5,"import":8,"new":[1,7],"null":8,"return":1,"static":1,"switch":5,"true":[1,4],AND:8,AWS:[1,5],Added:[5,7],And:8,For:[1,5,6,7],INTO:8,NOT:8,The:[1,6],There:6,These:8,Use:5,Uses:1,_generate_insert_sql:1,_get_cursor:1,_hook:5,_oper:5,_sensor:5,_serialize_cel:1,a28c66f23:5,a4dc11fa:5,a9ac2b040:5,about:5,ac2f72c98:5,access:1,act:1,acycl:8,adapt:1,add:[5,7],advanc:1,ae7cb4a1:5,aeea71274:5,after:6,aip:5,airflow:8,airflow_conn_:6,airflow_conn_postgres_default:6,all:[1,5,6,7,8],allow:6,alreadi:8,also:1,amazon:7,ani:1,ann:8,apach:8,api:7,appeal:8,application_nam:6,arg:[1,5],argument:1,attribut:8,authent:1,author:6,auto:5,autocommit:4,autom:5,automat:4,avail:8,awar:1,aws_conn_id:1,aws_default:1,awshook:1,b2a28d159:5,b40dffa08:5,backport:[5,7],base:[1,4,8],baseoper:[4,8],batch:5,been:7,begin:1,begin_d:8,below:8,best:8,between:8,binari:7,birth_dat:8,black:5,bool:[1,4],both:8,boto3:5,broken:5,build:5,bulk_dump:1,bulk_load:1,c34ef853c:5,c7e5bce57:5,ca4238eb4:5,cach:5,call:[1,8],can:[1,4,6,7,8],candid:5,carri:8,cat:8,catchup:8,cdec30125:5,cell:1,cert:[1,6],certif:6,chang:5,changelog:5,check:[1,5],choic:7,choos:1,claus:1,cleanup:5,client:[5,6],cluster:1,code:[4,8],column:1,come:5,command:[1,4,5,7],comment:5,commit:[4,5,7],compat:5,compon:6,conflict:1,conn:1,conn_id:6,conn_name_attr:1,conn_typ:1,connect:[1,4,5,7],constructor:5,contain:[6,8],context:4,control:6,convers:1,copi:1,copy_expert:1,correct:5,coverag:5,creat:1,create_pet_t:8,crl:6,cross:5,cursor:1,cursortyp:1,d0e7db402:5,d200:5,d305876be:5,dag:7,dag_id:8,data:1,databas:[1,4,6],date:8,datetim:8,dbapi:1,dbapihook:1,default_arg:8,default_conn_nam:1,defin:[4,8],deleg:8,delimit:1,depend:[5,8],deprec:7,detail:[1,5,6,7],determin:6,dev:5,dict:[4,5],dictcursor:1,dictionari:6,differ:8,direct:8,directli:8,directori:8,disabl:6,discoveri:5,doc:[1,5],document:[5,6,7],doe:[1,7],dog:8,down:8,downgrad:7,dump:[1,8],dure:8,dynam:[5,8],each:[1,4],eded:4,edg:8,ee7ca128a:5,eff1525d1:5,either:7,eleg:8,empti:1,enabl:5,encod:6,end:4,end_dat:8,error:7,essenti:8,establish:1,etc:1,eventu:8,everyth:8,exampl:[1,6,7,8],example_dag:8,example_postgr:8,execut:[1,4],exist:[1,7,8],explor:8,extra:[1,5,6,7],extract:1,f3521fb0e:5,f6bd817a3:5,fals:[4,8],fdd9b6f65:5,featur:[5,7],fed:8,field:[1,5,6],file:[1,4,5,6,7,8],filenam:1,fill:1,find:8,fix:5,flynt:5,folder:8,follow:6,form:5,formmatt:5,found:6,free:8,fresh:5,from:[1,5,7],full:6,gener:[1,5],get:[1,5,8],get_all_pet:8,get_birth_d:8,get_conn:1,get_iam_token:1,grammar:5,graph:8,guid:[5,7],hamster:8,has:[7,8],hash:5,have:[1,8],heavi:8,helper:1,henc:1,high:5,highlight:8,hood:8,hook:[2,5,8],hook_nam:1,host:[1,6],how:5,howev:1,howto:7,html:1,http:1,iam:1,identifi:1,implement:[5,8],improv:5,inact:6,includ:5,increas:5,index:1,inform:[1,5],inherit:8,initd:1,initi:7,inject:8,input:1,insert:1,insert_row:5,insid:8,instal:5,instanti:8,instead:[1,8],integr:5,interact:[1,8],interest:8,intern:1,introduc:5,involv:8,isn:8,iter:[1,4],its:[1,8],jane:8,json:6,keepal:6,keepalives_idl:[1,6],kei:[6,8],kwarg:[1,4],latest:5,lead:7,leav:1,legaci:7,less:1,lester:8,let:8,level:5,lift:8,like:8,lili:8,link:5,list:[1,4,5,6,7],load:1,login:6,logo:5,look:8,made:8,magic:5,maintain:8,make:[5,8],mani:8,map:4,markdown:5,match:5,max:8,messag:6,method:1,might:7,miss:5,mode:6,model:4,modul:5,month:5,more:[1,6,8],move:5,my_aws_conn:1,my_cluster_id:1,mysql:1,name:[1,4,5,6,8],necessari:1,need:7,negoti:6,node:8,none:[1,4,5],note:[1,5,6],novemb:7,now:8,number:[5,6],object:[1,8],octob:5,offer:8,onc:8,one:4,oper:[1,2,5,7],option:[1,4,6,7],order:7,org:1,our:8,out:[5,6,8],overrid:1,overridden:1,overwrit:4,owner:8,packag:8,page:5,pain:8,param:8,paramat:5,paramet:[1,4,5,6],parent:8,parrot:8,pass:[5,6],password:[1,6],path:1,pem:[1,6],per:5,pet:8,pet_id:8,pet_schema:8,pet_typ:8,phil:8,pip:5,pipelin:8,point:5,popul:8,populate_pet_t:8,port:1,possibl:8,postgr:6,postgreoper:8,postgres_conn_id:[1,4,8],postgres_default:[1,4,8],postgres_operator_dag:8,postgres_us:6,postgresdb:6,postgreshook:[1,5,8],postgresoper:[4,5,7],postgresql:[1,5,7,8],practic:8,prefer:6,prepar:5,prevent:8,primari:8,prioriti:6,project:5,provid:[6,8],psycopg2:[1,5,7],psycopg:1,purpos:8,put:8,pydocstyl:5,pylint:5,pypi:[5,7],python:[5,6,7],pyupgrad:5,queri:[4,8],quickli:8,quinci:8,quit:8,raw_cursor:1,rc3:5,readm:[5,7],receiv:4,recogn:4,redshift:1,redund:5,ref:5,refactor:8,refer:[1,4,5,7],refernc:5,regener:5,relas:5,releas:[5,7],rema:5,remain:5,remov:5,renam:5,render:4,replac:[1,6],replace_index:1,repositori:7,repres:4,request:8,requir:[1,6,8],resid:8,resolv:7,resourc:7,retriev:1,revoc:6,road:8,robust:8,row:1,runtim:8,sai:8,schedule_interv:8,schema:6,script:5,second:[1,6],secur:6,see:[1,5],select:8,self:[1,4],send:6,sensor:5,separ:5,serial:8,server:6,servic:1,set:1,setup:5,should:[5,6,8],signatur:5,simpl:8,simplehttpoper:5,simpli:8,six:6,snippet:8,softwar:5,solut:8,somewher:8,sourc:[1,4,8],specif:[1,4],specifi:[1,6,7],sql:[1,4,8],ssl:[1,6],sslca:6,sslcert:[1,6],sslcrl:6,sslkei:6,sslmode:[1,6],sslrootcert:6,standard:6,start_dat:8,statement:[1,4,8],store:8,str:[1,4],string:[1,5],subdirectori:8,subject:5,succe:1,superus:1,support:[5,6],supports_autocommit:1,susi:8,symmetr:8,syntax:[1,6],tab:1,tabl:1,takeawai:8,target:1,target_field:1,task:8,task_id:8,tcp:6,templat:4,template_ext:4,template_field:4,template_fields_rend:5,template_fields_render:4,temporari:1,test:5,than:1,thei:1,them:7,themselv:1,thi:[1,5,6,7,8],thing:8,those:7,tidi:8,time:8,tmp:6,tmp_file:1,toc:5,togeth:8,token:1,tool:5,top:7,transfer:5,trove:8,tupl:1,two:8,type:[1,5,6,7],typo:5,ui_color:4,under:8,union:4,unit:8,unless:1,updat:[5,7],upgrad:[5,7],upsert:5,uri:6,url:6,use:[1,5,7,8],used:[1,6,8],user:[1,6],using:[1,5,8],utf:5,valu:[1,4,6,8],varchar:8,variabl:6,variant:1,variou:8,verifi:6,version:[5,7],via:7,view:8,virtu:8,wai:8,want:1,warn:5,what:6,when:[1,6,7,8],where:[6,8],whether:[1,6],which:[4,6,8],without:1,word:5,work:[7,8],workflow:8,wrong:5,wrongli:5,xxxxxxxxxxxx:6,yet:7,you:[1,6,7,8],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>","How-to Guide for PostgresOperator"],titleterms:{The:8,airflow:[0,1,2,3,4,5,7],apach:[5,7],changelog:7,common:8,complet:8,conclus:8,configur:6,connect:6,content:[1,4,7],creat:8,cross:7,dag:8,data:8,databas:8,depend:7,fetch:8,from:8,guid:8,hook:[0,1],how:8,insert:8,instal:7,introduct:8,modul:[1,4],oper:[3,4,8],packag:[5,7],paramet:8,pass:8,pip:7,postgr:[0,1,2,3,4,5,7,8],postgresoper:8,postgresql:6,provid:[0,1,2,3,4,5,7],record:8,requir:7,submodul:[0,3],subpackag:2,tabl:8,your:8}})