Skip to main content

My PostgreSQL crash course

PostgreSQL is a powerful open source relational database. If you have worked with MySQL before, PostgreSQL will feel familiar but with additional enterprise features.

First install PostgreSQL using your package manager. On Ubuntu: 
sudo apt install postgresql
Once installed, check service status: 
sudo systemctl status postgresql
Switch to postgres user: 
sudo -i -u postgres
Enter PostgreSQL prompt: 
psql
To list databases: 
\l
To create a new database: 
CREATE DATABASE mydb;
To connect to it: 
\c mydb
To create a table: 
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name TEXT,
email TEXT
);
To insert data: 
INSERT INTO users (name, email) VALUES ('John', '[john@example.com](mailto:john@example.com)');
To query data: 
SELECT * FROM users;
To exit: 
\q
PostgreSQL is reliable, standards compliant, and production ready.

Disclaimer: If you follow the information here, there is no warranty, I am not liable if it deletes your data, gets you hacked, burns your house down or anything else. If you follow the information contained here you do so entirely at your own risk.  My views and opinions are my own and not necessarily represent the views of my employer.

© Raheel Hameed and www.raheelhameed.com, 2017. Unauthorized use and/or duplication of this material without express and written permission from this site’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to author and this website with appropriate and specific direction to the original content.
Disclaimer: If you follow the information here, there is no warranty, I am not liable if it deletes your data, gets you hacked, burns your house down or anything else. If you follow the information contained here you do so entirely at your own risk.  My views and opinions are my own and not necessarily represent the views of my current or former employers.

© Raheel Hameed and www.raheelhameed.com, 2017. Unauthorized use and/or duplication of this material without express and written permission from this site’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to author and this website with appropriate and specific direction to the original content.

Comments

Post a Comment

Popular posts from this blog

My MongoDB crash course

MongoDB is a NoSQL database that stores data in flexible JSON like documents. Unlike relational databases, MongoDB does not require a fixed schema. This makes it very convenient for applications where structure may evolve over time. First install MongoDB. On Ubuntu you typically add the official MongoDB repository and then install: sudo apt install mongodb Once installed, check service status: sudo systemctl status mongodb If it is not running, start it: sudo systemctl start mongodb To access MongoDB shell: mongo You should now be inside the MongoDB interactive shell. To show databases: show dbs To create or switch to a database: use mydb MongoDB creates the database automatically when you first store data. To insert a document: db.users.insertOne({ name: "John", email: "[john@example.com](mailto:john@example.com)", age: 30 }) To find documents: db.users.find() To pretty print results: db.users.find().pretty() To update a docum...
Post a Comment
Read more

My HTOP crash course

Htop is an interactive process viewer. Install: sudo apt install htop Run: htop You will see CPU usage, memory usage, and running processes. Use arrow keys to navigate. Press F9 to kill a process. Press F10 to exit. Htop is easier to read than traditional top command. Monitoring your system regularly helps prevent surprises. Disclaimer: If you follow the information here, there is no warranty , I am not liable if it deletes your data, gets you hacked, burns your house down or anything else. If you follow the information contained here you do so entirely at your own risk . My views and opinions are my own and not necessarily represent the views of my employer. © Raheel Hameed and www.raheelhameed.com, 2017. Unauthorized use and/or duplication of this material without express and written permission from this site’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to author and this ...
Post a Comment
Read more

My Makefile crash course

Make automates build processes. Create a file named Makefile: all: gcc main.c -o app To run: make To clean build artifacts: clean: rm -f app Run: make clean Make uses tabs before commands. Spaces will not work. Make is useful even for small projects. Disclaimer: If you follow the information here, there is no warranty , I am not liable if it deletes your data, gets you hacked, burns your house down or anything else. If you follow the information contained here you do so entirely at your own risk . My views and opinions are my own and not necessarily represent the views of my employer. © Raheel Hameed and www.raheelhameed.com, 2017. Unauthorized use and/or duplication of this material without express and written permission from this site’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to author and this website with appropriate and specific direction to the original content.
Post a Comment
Read more