postgres-intro Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
PostgreSQL is a powerful, free, open source Relational Database Management System (RDBMS).
Other popular relational databases include MySQL (also free), SQL Server by Microsoft, and Oracle by Oracle Corporation.
2
Q
What are some advantages of learning a relational database?
A
Keeping data integrity.
SQL language is a very portable skill given that there are so many relational databases driven by almost the same language.
3
Q
What is one way to see if PostgreSQL is running?
A
top command (to list the currently running processes) Execute sudo service postgresql status command while Postgres is running.