PostgreSQL Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
-open source relational database
MySQL, Oracle, MariaDB MySQLite
2
Q
What are some advantages of learning a relational database?
A
- most common type of db
- once you know one, you’ll understand them all
- prevents data corruption
3
Q
What is one way to see if PostgreSQL is running?
A
top, psql
4
Q
What is a database schema?
A
Collection of tables, defined how the data in a relational database should be organized
5
Q
What is a table?
A
a list of rows each having the same set of attributes
