postgres-intro

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

It is a relational database that stores information and relates that information to other groups of information through tables. MySQL and SQL Server by Microsoft.

Question 2

What are some advantages of learning a relational database?

Answer 2

They have data integrity and make data corruption as unlikely as possible. Learning SQL is a transferrable skill that allows you to use most other relational databases.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

sudo service postgresql status

Question 4

What is sudo?

Answer 4

elevates the user to admin status in the CLI environment.

Question 5

What is the admin acc in linux?

Answer 5

root, and to get there you type sudo su to make yourself root.

Question 6

Why must we use sudo to access the status of postgresql?

Answer 6

Admin privileges are required to access the postgresql service database.

Question 7

How do you send a command to get a list of the databases in postgresql?

Answer 7

psql -c “\l”

Question 8

How do you connect to a particular database in postgresql?

Answer 8

psql database_name or in our environment to connect to the dev database just enter psql