PostgreSQL.md

PostgreSQL

---

Install

Amazon Linux 2023

sudo dnf install -y postgresql15

Amazon Linux 2

sudo amazon-linux-extras install -y postgresql14

---

connect

# Export
ENDPOINT_URL="<DB_ENDPOINT>"
PORT="<PORT>" # Default Port Number : 5432
USER_NAME="<USER_NAME>"
DB_NAME="<DB_NAME>"

# Connect
psql --host=$ENDPOINT_URL --port=$PORT --username=$USER_NAME --password --dbname=$DB_NAME

---

DataBase Example

Create DataBase

CREATE DATABASE demo with owner postgres;
\l+
\c demo;

Create Schema

CREATE SCHEMA wsi authorization postgres;
set search_path to wsi;
\dn+

Create Table

CREATE TABLE public.user_table (
    user_id INT NOT NULL AUTO_INCREMENT,
    user_name VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    PRIMARY KEY(user_id)
);
\dt

Add Data in Table

INSERT INTO public.user_table(user_name, password) VALUES ('admin', 'Skil39!@#');

Select Table

SELECT * FROM public.user_table;

Update Data in Table

UPDATE public.user_table SET password = 'Skill53##' WEHETE user_name = 'admin';

Delete Data in Table

DELETE FROM public.user_table WHERE user_name = 'admin';