PostgreSQL command line:
Connecting to PostgreSQL
This will connect you to the PostgreSQL server as the specified user and database.
Creating a table
This will create a table with the specified name and columns.
Inserting data into a table
This will insert a new row into the specified table with the specified values.
Selecting data from a table
This will select all of the rows from the specified table. You can also specify specific columns to select by adding their names to the
Updating data in a table
This will update the value of the
column_name column in all of the rows in the table that meet the
Deleting data from a table
This will delete all of the rows in the table that meet the
Other common commands
\l: List all of the databases on the server.
\c database_name: Connect to the specified database.
\d table_name: Describe the specified table.
\q: Quit PostgreSQL.
# Create a table called users with two columns, id and name
CREATE TABLE users (
id INT PRIMARY KEY,
# Insert a new row into the users table
INSERT INTO users (id, name) VALUES (1, 'John Doe');
# Select all of the users from the users table
SELECT * FROM users;
# Select the user with the ID of 1
SELECT * FROM users WHERE id = 1;
# Update the name of the user with the ID of 1 to "Jane Doe"
UPDATE users SET name = 'Jane Doe' WHERE id = 1;
# Delete the user with the ID of 1
DELETE FROM users WHERE id = 1;
Created: September 20, 2023