[Airflow] airflow에 연결된 postgreSQL 테이블 확인하기

https://github.com/ParkGyeongTae/airflow-pgt/tree/main/0_airflow

GitHub - ParkGyeongTae/airflow-pgt

 

sudo -u postgres psql -U postgres -c "\list"

 

sudo -u postgres psql -U postgres -d airflow -c "\list"

 

sudo -u postgres psql -U postgres -d airflow -c "\dt"

 

sudo -u postgres psql -U postgres -d airflow -c "\ds"

 

sudo -u postgres psql -U postgres -d airflow -c "\du"

 

sudo -u postgres psql -U postgres -d airflow -c "\dt+"

 

sudo -u postgres psql -U postgres -d airflow -c "\ds+"

 

sudo -u postgres psql -U postgres -d airflow -c "\dt+"
sudo -u postgres psql -U postgres -d airflow -c "\d job"

 

sudo -u postgres psql -U postgres -d airflow -c "\dt+"
sudo -u postgres psql -U postgres -d airflow -c "\d log"

 

 

sudo -u postgres psql -U postgres -d airflow -c "\d dag"

 

sudo -u postgres psql -U postgres -d airflow -c "select * from dag"

 

sudo -u postgres psql -U postgres -d airflow -c "select * from log"

 

sudo -u postgres psql -U postgres -d airflow -c "select * from job"