for viewing Task 43 data model in PG Admin
docker-compose up -d
p: root
you may be prompted for a password to connect to the database, password is root
you can view an ERD that was created previously by clicking Tools > ERD Tool > then click the folder button to open any ERD file that's there
- connect as in above
- click
Add New Server
- Name: task43ex
- Connection: [your-LAN-IP-address]
- Username: root
- Password: root
- in the left pane, navigate to task43ex > Databases > test_db > Schemas > public
- right click on public and click
CREATE Script
- delete what's in the Query Editor, paste in the
task43_postgre.sql
script and run with play button - clear again, paste in the contents of the
iea43_wra_data_model_demo_data.sql
file, and run again 1 in the left pane, right-clicktest_db
and chooseGenerate ERD