What Is PostgreSQL? What Are Its Features and Use Cases?

CREATE DATABASE: Creates a new database. 
 CREATE DATABASE dbname; 

DROP DATABASE: Deletes an existing database.  
 DROP DATABASE dbname; 

\c: Connects to a specific database. 

CREATE TABLE: Creates a new table.  
 CREATE TABLE tablename ( 
     column1 datatype, 
     column2 datatype, 
     ... 
 ); 
 ALTER TABLE: Modifies an existing table 
 ALTER TABLE tablename ADD column datatype; 

DROP TABLE: Deletes an existing table. 
 DROP TABLE tablename; 

\d: Describes the structure of a table. 
 \d tablename 

CREATE DATABASE: Creates a new database. 
 CREATE DATABASE dbname; 

DROP DATABASE: Deletes an existing database. 
 DROP DATABASE dbname; 
 \l: Lists all databases. 
 \l 

INSERT INTO: Inserts new rows into a table. 
 INSERT INTO tablename (column1, column2, ...) VALUES (value1, value2, ...); 

SELECT: Retrieves data from one or more tables. 
 SELECT * FROM tablename; 

UPDATE: Modifies existing data in a table. 
 UPDATE tablename SET column = value WHERE condition; 

DELETE: Deletes rows from a table. 
 DELETE FROM tablename WHERE condition; 

CREATE INDEX: Creates an index on a table. 
 CREATE INDEX indexname ON tablename (column); 

CREATE VIEW: Creates a virtual table based on the result of a query. 
 CREATE VIEW viewname AS SELECT * FROM tablename WHERE condition;