psql

https://velog.io/@cataiden/psql-on-your-mac

brew install libpq

echo 'export PATH="/opt/homebrew/opt/libpq/bin:$PATH"' >> ~/.zshrc

source ~/.zshrc

psql --version

이제 로컬 환경에 직접 DB 를 설치할 필요없이 psql 이나 pg_dump 와 같은 인터페이스를 사용할 수 있습니다.

psql -h aws-0-ap-northeast-2.pooler.supabase.com -p 6543 -d postgres -U postgres.bwikxbqogmxuszagwxxx

https://access.redhat.com/documentation/ko-kr/red_hat_enterprise_linux/9/html/configuring_and_using_database_servers/backing-up-postgresql-data_using-postgresql

1.

pg_dump -h aws-0-ap-northeast-2.pooler.supabase.com -p 6543 -d postgres -U postgres.bwikxbqogmxuszagwxxx -t documents > documents.sql
Password: xxx

2.

psql -h aws-0-ap-northeast-2.pooler.supabase.com -p 6543 -d postgres -U postgres.frqiaplbrdtwfdfpuxxx < documents.sql
Password: xxx