dev-resources.site

for different kinds of informations.

How to Create, Update, and Delete Database in Postgres

Published at

10/24/2024

Categories

Author

Md Enayetur Rahman

Main Article

https://dev.to/md_enayeturrahman_2560e3/how-to-create-update-and-delete-database-in-postgres-34kh

Categories

1 categories in total

How to Create, Update, and Delete Database in Postgres

Open SQL Shell.
Provide your username and password.
Type the following command

CREATE DATABASE your_database_name;

If the database is created successfully you will see the "CREATE DATABASE" message.
Type the following command to see all the databases.

\l

If you want to change the name of the database you can use the following command

ALTER DATABASE your_database_name RENAME TO new_database_name;

If the database name is changed successfully you will see an "ALTER DATABASE" message.
If you want to delete the database you can use the following command

DROP DATABASE your_database_name;

If the database deletes successfully you will see a "DROP DATABASE" message.

Articles

12 articles in total

Pagination and Sorting with Prisma in TypeScript

Prisma CRUD Operations Guide

Organizing Find Operations in Prisma with TypeScript

Understanding Prisma Models: A Beginner's Guide with Examples

Getting Started with Prisma: A Comprehensive Guide

Understanding PostgreSQL Data Types: Why They Matter and How to Use Them Effectively

How to Create, Update, and Delete Database in Postgres

currently reading

How to create new user, and database in Postgres and grant and revoke permission

How to install Postgres on your Windows machine

The Foundation of Modern Computing: Transistors, Binary, and Bits

State Management in React Using `useReducer`: A Comprehensive Guide

Managing Global State in React with `useContext` and `useReducer`: A Todo App Example

Featured ones:

abubakersiddique761