> For the complete documentation index, see [llms.txt](https://automatethem.gitbook.io/supabase-js-doc/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://automatethem.gitbook.io/supabase-js-doc/psql.md).

# 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
```