add an api to restore postgres schema

Hi, I think something like this can be useful: An api to restore postgres schema that dump later with #1967

Also It can be very useful for this issue: #2103

The combination of a pg_dump / pg_restore API would be particularly useful for replicating data to new cloud environments.