How to Import and Export PostgreSQL database? | Import and export database | postgresql database |

How to Import and Export PostgreSQL database? | Import and export database | postgresql database | TechEasy

Hi
I am Amit Hadole Welcome to our youtube channel TechEasy

🔳 About this video:
In this video, you are going to learn how to import and export the PostgreSQL database using pgadmin in simple way.

🔲 Steps to push code to GitHub:
00:00 Intro
00:22 Check databases
00:53 Export the database
01:18 Give name to exported database
02:04 Check exported database file
02:26 Create new database
03:02 Import the database.

🔳 PostgreSQL is
◻️ An advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.
◻️ A highly stable database management system, which has contributed to its high levels of resilience, integrity, and correctness.
◻️ Used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.

🔲 Benefits of PostgreSQL :
◼️ Rich features and extensions
◼️ Reliability and standards compliance
◼️ Open source license
🔳 Language support to PostgreSQL :
✔️ Python
✔️ .Net
✔️ C/C++
✔️ Java
✔️ Go
✔️ Tcl
✔️ Perl
✔️ Ruby
✔️ ODBC

🔲 Steps to Export and Import(restore) database :
🔸 Step 1: Open pgadmin.
🔹 Step 2: Select and right click the database you want to export.
🔸 Step 3: Select the location for storing the database file.
🔹 Step 4: write the filename with ".sql" extension and click to create
🔸 Step 5: For importing database, first create new database.
🔹 Step 6: Right click to that database and select and click to restore.
🔸 Step 7: Restore successfully completed.
🔹 Step 8: Go to database right click and refresh it.
🔸 Step 9: All the tables are successfully imported imported.

Hope this small video will help us to import and export the PostgreSQL database 🙂

👇 My gadgets :-
🔸 Lenovo wireless mouse - https://amzn.to/2VlcKb2
🔹 Boya Mic - https://amzn.to/3rCmKsq
🔸 My Smartphone - https://amzn.to/3ybobk0
🔹 Mobile tripod (stand) - https://amzn.to/3f4l4Tr

🔴 Subscribe to our channel to get video updates. Hit the subscribe button above:
👉 https://www.youtube.com/channel/UCMuc...

#importpostgresql #exportpostgresql #psqldatabase #TechEasy

Видео How to Import and Export PostgreSQL database? | Import and export database | postgresql database | канала TechEasy