How to Connect VSCode With PostgreSQL Database | Run SQL Queries
In this lecture I will show you How to connect VSCode With PostgreSQL database and run SQL queries.We'll learn how to establish connection with PostgreSQL from Visual Studio Code.PostgreSQL in Visual Studio Code.
#postgresqltutorial #vscode #visualstudiocode #sql
CREATE TABLE Users (
user_id INT PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL
);
INSERT INTO Users (user_id, first_name, last_name, email)
VALUES
(1, 'Alice', 'Smith', '[email protected]'),
(2, 'Bob', 'Johnson', '[email protected]'),
(3, 'Charlie', 'Brown', '[email protected]');