HomeОбразованиеRelated VideosMore From: azamsharp

Exporting and Importing PostgreSQL Databases

106 ratings | 27923 views
Html code for embedding videos on your blog
Text Comments (13)
Amit Kumar (12 days ago)
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.
Doston Hamdamov (22 days ago)
Thanks
thanks
Christopher Trauco (2 months ago)
Short, sweet, and precise, thank you!
Amit Kumar (6 months ago)
how to pg_dump remote aws postgres instace from local ubuntu machine
Bojan Jovanovic (7 months ago)
Thank you very much for this video, simple, short, great example!
Глеб Хайкин (11 months ago)
Thank you! It's quite relevant!
Victoria Rodríguez (1 year ago)
Really helpful, thanks <3
Asma Khan (1 year ago)
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?
thanks it's really helpful
Kyle Abens (1 year ago)
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!
abi a (1 year ago)
pg_dump related issues is easily explained in www.sakthidbtech.com
Kyle Abens (1 year ago)
Looks like I have to specify the entire path to pg_dump in order to use it. I created a dump.sql file using pg_dump but when I open it all I see are a long list of 4 digit codes. Any idea why I'm not seeing the same thing as you?

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.