Differences

This shows you the differences between two versions of the page.

--- weatherbox:database:postgres [2017/10/04 00:22]
kcho
+++ weatherbox:database:postgres [2021/09/19 21:59] (current)
@@ Line 15: / Line 15: @@
-The control_tower user hosts all the tables for the weather boxes in the lab.  To see the tables run the command \dt to show all database tables.
+The only user that has super user access on the lab computer's postgreSQL database. In order to allow the API to connect to the database and have read/write permissions, the postgres user must be used. As such, the credentials saved on the computer use postgres with the password lists above.
+Postgres user hosts all the tables for the weather boxes in the lab.  To see the tables run the command \dt to show all database tables.
+To get to the example bears api table use the following commands after logging in as any user.
+\c bears;
+SELECT * FROM BEARS;
+====== Things to do ======
+* Need to figure out permissions to each table for each users. (kluong, control_tower, postgres)