ec2-database-connect

database-1

sudo dnf update -y

sudo dnf install postgresql15

psql --host=<REPLACE-ENDPOINT> --port=5432 --dbname=postgres --username=postgres

SELECT CURRENT_TIMESTAMP;

CREATE DATABASE db1;

\l

\c db1

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

INSERT INTO users (name, age) VALUES ('John Doe', 30);

SELECT * FROM users;