SQL

Postgres Cheat Sheet

**1. Creating a Database **
CREATE DATABASE db_name;

2. Deleting a Database
DROP DATABASE db_name;

3. Listing all Databases
\l

4. Connecting to a Database (must be done before you can create or affect any tables in that database)
\c db_name

5a. Creating a Table
CREATE TABLE table_name ( id serial4 primary key, var_name_1 varchar(40), var_name_2 text );

5b. Creating a Table (alternate)
CREATE TABLE table_name(id serial4 primary key, var_name1 varchar(40), var_name2 text);

6. Deleting a Table
DROP TABLE table_name;

7. Viewing Info about all of the Tables in a Database \d

8. Viewing Info about a specific Table in a Database
\d table_name

9. Adding (Inserting) Data into a Table
INSERT INTO table_name (column_name_1, column_name_2, column_name_4) VALUES (value_1, value_2, value_3);

10a. Retrieving (Selecting) Data from specific columns in a Table
SELECT (column_1, column_2, column_5, column_8) FROM table_name;

10b. Retrieving (Selecting) Data from all columns in a Table
SELECT * FROM table_name;

11. Deleting rows from a table
DELETE FROM table_name WHERE column_1 = value_1, column_4 = value_4;

12. Changing (updating) rows in a table
UPDATE table_name SET column_1 = value_1, column_3 = value_3 WHERE column_1 = old_value_1, column_4 = old_value_4