PostgreSQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
psql -d my_test_db | psql -d my_test_db | ||
== Comparison with MySQL == | |||
* Both default to using a socket for local connections on Unix hosts (instead of TCP/IP) | |||
== Links == | == Links == | ||
* [https://wiki.postgresql.org/wiki/Don't_Do_This Don't Do This] - list of things not to do in PostgreSQL, with explanations. | * [https://wiki.postgresql.org/wiki/Don't_Do_This Don't Do This] - list of things not to do in PostgreSQL, with explanations. | ||
Revision as of 09:49, 6 January 2022
Ubuntu installation
Install PostgreSQL and its contrib package:
sudo apt install postgresql postgresql-contrib
Create a new user (with the same username as your Linux login):
sudo -u postgres createuser --interactive
Create a database:
createdb my_test_db
Connect via psql:
psql -d my_test_db
Comparison with MySQL
- Both default to using a socket for local connections on Unix hosts (instead of TCP/IP)
Links
- Don't Do This - list of things not to do in PostgreSQL, with explanations.