Exporting and Importing PostgreSQL Databases

Book: Surviving the Coding Bootcamp - From no coding experience to earning a six-figure salary

Check out my courses:

Get courses from Big Mountain Studio:

1. Combine Mastery in SwiftUI

2. SwiftUI Animations

3. SwiftUI Views Mastery

4. Visual Swift Memory Mastery

5. Working with Data in SwiftUI

6. SwiftUI in UIKit Weekened Kickstarter

[itrauco]

Short, sweet, and precise, thank you!

[sweetentertainment]

life saving. thanks for the video. I am totally new in database handling but in my current project I have to deal with some database stuffs and It was a life savior for me. Thanks for the video.

[MentholCiC]

Thank you very much for this video, simple, short, great example!

[asmakhan]

thanks for the video, i want to know how to connect to a remote database like DB2, extract data from a table and load a postres table..is there a way i can create a script and run it..i tried unloading CSV files and loading CSV file using Pgadmin 4..it worked
but i need something like a script which can be executed for each table and it should extract data and load the data to postgres..is it possible?

[sofiapontigo]

Excellent video! how can i import a large set of postgresql databases? Is there anyway to do it quickly? Thank you!

[vb]

Well, this video helped. Its somewhat outdated and it lacks certain complexity that will cause errors. But once I added whats needed, it worked just fine.
Thankou

[arrestedmoments]

I have a aws postgres rds, under this have two rds, so I want to export one database table data to another database table mean table to table data transfer, but here problem is facing with error like constraint and fkey error while importing the table data from one table to another. I heard some XML data solution to resolve this issue and may be possible by exporting the XML data and importing the same into another table but not sure about this option, .
Can you suggest if you have done something similar for aws postgres rds.

[roundtheworld]

The only thing like to mention, if we like to create a database with hyphen or a dash, we may try like this # CREATE DATABASE "TASKS-BACKUP";

[animecrazyluv]

Whenever I run psql it does not work saying the command is not found... I am trying to import an sql file to a postgres database.

[kyleabens]

For some reason when I run pg_dump it says 'pg_dump: command not found' and I'm not sure why. I'm on a mac, and I have downloaded PostgreSQL and I have multiple databases that I access via pgadmin. Any idea why I'm getting this message? Thanks in advance!

[mdkhan]

Hi Azam, can pg_dump be used for migration from 8.4 to 10x on different machine ?

[maliksafi]

Too bad the “command not found” error keeps coming up. This might have been helpful

[bqbuofg]

bad «No such file or directory», why? help me please

[HungNguyen-lepg]

pg_dump --no-owner tasksdb > dump.sql
psql tasksdb-backup < dump.sql