I'm using Postgres and I have a SQL dump (which has only public schema data). Now, I want to load dump data into particular "xxx" schema (This is other database). How can i do this ?
Asked
Active
Viewed 29 times
0
-
Is that a SQL dump (`pg_dump -Fp`) or a custom format (`pg_dump -Fc`) dump ? – Sep 16 '19 at 12:15
-
Yes, it's SQL dump – Yasir Asarudheen Sep 16 '19 at 12:18
-
Here, I'm using this command to getting dump :- pg_dump -U postgres -h localhost -d dbname > filename.sql – Yasir Asarudheen Sep 16 '19 at 12:25