1. postgresql 설치
https://get.enterprisedb.com/postgresql/postgresql-12.17-1-windows-x64.exe
2. dbweaver 설치
https://download.dbeaver.com/community/23.3.0/dbeaver-ce-23.3.0-x86_64-setup.exe
3. pgadmin4 접속
query tool -> select 'data';
4. sample db install
https://www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/
PostgreSQL Sample Database
Summary: in this tutorial, we will introduce you to a PostgreSQL sample database that you can use for learning and practicing PostgreSQL. We will use the DVD rental database to demonstrate the features of PostgreSQL. The DVD rental database represents the
www.postgresqltutorial.com
https://www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip
압축 해제
5. create database dvdrental
6. dvdrental 오른쪽 restore
오류시 : File -> preferenes -> pathes -> binary paths -> pg_restore.exe 경로 설정(C:\Program Files\PostgreSQL\11\bin)
'데이터 아키텍처 & 처리기술 & DBMS > Postgresql' 카테고리의 다른 글
| pg_restore.exe' file not found. (0) | 2023.12.24 |
|---|---|
| Postgresql Restore 문제 (0) | 2023.12.24 |
| PostGreSQL 제약사항 (0) | 2023.12.24 |
| PostgreSQL License 정책 (0) | 2023.12.24 |
| PostgreSQL과 Oracle Object 비교 (0) | 2023.12.24 |