filmov
tv
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 :-
🔴 Subscribe to our channel to get video updates. Hit the subscribe button above:
#importpostgresql #exportpostgresql #psqldatabase #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 :-
🔴 Subscribe to our channel to get video updates. Hit the subscribe button above:
#importpostgresql #exportpostgresql #psqldatabase #TechEasy
Комментарии