Skip to content

Latest commit

 

History

History
31 lines (21 loc) · 1.21 KB

README.md

File metadata and controls

31 lines (21 loc) · 1.21 KB
Raw

Myfiurevamp-backend

Backend for MyFIU

Postgres Database:

IMPORTANT: Read all comments in all SQL files! Important rules regarding tables, queries, and functions are documented that must be adhered to!

Main functions include:

  • inserting/updating students
  • validating superusers and guests
  • inserting offered courses
  • recording transcripts

To connect to the database:

  • install PostgreSQL
  • open up a terminal window and type psql -h hostname -U postgres where hostname is the name of the host or the IP address that the database is on.
  • enter password
  • connect to database enter \c myfiurevamp

When connected to the database:

All SQL queries can be performed on the command line. Try select * from student;

Note: When executing queries, be sure to end them with a semicolon ; or psql will think you are entering a new line. If this happens, simply type ; and enter a new line.

To list all tables, enter \dt. To describe a table, enter \d table-name.