Search Postgresql Archives

using pg_dump to dump only a schema?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hi there,

i'm wondering, if i can use pg_dump to move only one schema of a db from the one server, intoan other schema on the other server?

for example:

Server A:
Database: xyz_test
Schema: 123

Server B:
Database: xyz_prod
Schema: 999


The tablenames and so on are equal. and i wan't to transfer the data with it. is it possible? and how? today i played a little bit with it, but could not find a proper way with it. the description in the docu didn't helped me either. any solution anyone?

thanx in advance!

bye,
thomas


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
     message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux