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

Published: 12 December 2021
on channel: TechEasy

30,687

287

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

On this page of the site you can watch the video online How to Import and Export PostgreSQL database? | Import and export database | postgresql database | with a duration of hours minute second in good quality, which was uploaded by the user TechEasy 12 December 2021, share the link with friends and acquaintances, this video has already been watched 30,687 times on youtube and it was liked by 287 viewers. Enjoy your viewing!

16,802